Recommended Posts

Ah - I didn't realise you were using SQL Express :(

You could still do this with a combination of Windows scheduled tasks and Jobs within SQL Server but it'd be pretty cludgy.. :( What you'd want to do would be doing transaction log backups rather than full database backups which would mean the file you needed to copy over was smaller and would take less time to restore.. that's what (unsurprisingly) log shipping does :)

Sorry - I forgot to say.. In terms of what you use, it depends on how you want to use the 'backup' database - is it to be used as a standby system, or are you just going to be doing reporting off the database or subsets of the data?

OK - logshipping would do exactly what you want. The only thing you need to bear in mind is that, AFAIK, logshipping will only be backing up the contents of the database. Any other things you change (such as adding new users, etc) will not come across in the logshipping - so any such changes that you make to one server, you'll need to do to the other.

Have you tried on the client PC that is connecting to the VPN...

Open Network Connections, Right click the VPN Network Adapter -> Properties -> Networking -> Double click Internet Protocol Version 4 - > Click Advanced -> Untick Use default gateway on remote network.

Have you tried on the client PC that is connecting to the VPN...

Open Network Connections, Right click the VPN Network Adapter -> Properties -> Networking -> Double click Internet Protocol Version 4 - > Click Advanced -> Untick Use default gateway on remote network.

That was it :) found it after a quick help from google lol

.Problem im having now is

Cannot open backup device '\\server2\backups\test.bak'. Operating system error 5(error not found).

RESTORE FILELIST is terminating abnormally. (Microsoft SQL Server, Error: 3201)

Both backup folders have full write/read access to folders and i can manually copy those folders across.

Ed

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • "Samsung is shutting down yet another app used by millions" I will fix the clickbait title for you, free-of-charge: "Samsung shutting down it's Max VPN app"
    • Microsoft brings Planner Agent to all Microsoft 365 Copilot users by Ivan Jenic Image: Microsoft Microsoft has announced that Planner Agent in Microsoft 365 Copilot is now generally available to all users with a Microsoft 365 Copilot license. Planner Agent is the latest addition in the string of AI features that Microsoft is implementing across virtually all of its products. The agent lets you manage tasks through natural language prompts directly inside Microsoft 365 Copilot. You can create and update tasks, check priorities, and get insights about current entries without leaving the chat interface. The general availability release comes with a handful of new additions on top of what was available during the initial rollout. A new plan picker lets you search and filter your plans by name, then update task names, statuses, due dates, or priorities through the agent. There's also a goals bucket now, which lets you group tasks under specific goals. This builds on the Goals view, a feature that was introduced as part of the broader Planner refresh that rolled out earlier. Image: Microsoft | Planner Agent in Microsoft 365 Copilot All AI-generated plans and tasks are created in draft mode by default, so you can review and approve changes before anything goes through. This is actually a thoughtful safety feature, because trusting AI to handle all your tasks without a human in the loop is usually a recipe for disaster. Having tasks initially saved as drafts is the best possible middle ground. Microsoft also says that not all tasks are executed equally. Simple tasks get processed quickly, while more complex ones, like building a plan from a Word, Excel, or PowerPoint file, are handed to a more capable model. Microsoft says this approach delivers the best performance, but it could also help with usage management, as you won't have to waste tokens on performing simple tasks. Planner Agent is available now across Teams, Loop, SharePoint, and other Microsoft 365 apps for anyone on a Microsoft 365 Copilot subscription.
    • To be clear I'm anti trump, the bigger point is why review this game at all?
    • Trillion dollar Microsoft has to reduce spending by hurting more people. Good job Microsoft. Good Job Asha.
    • That's a shame. The big Xbox reset when Phil and Sarah left and then Asha came on and brought a new team of executives, and all the layoffs last year and saying that the ABK merger wouldn't result in redundancies I am surprised they are calling for yet another reset and yet more layoffs.
  • Recent Achievements

    • First Post
      Cosminus earned a badge
      First Post
    • One Year In
      ThatGuyOnline earned a badge
      One Year In
    • Week One Done
      Jeroen Wilms earned a badge
      Week One Done
    • Week One Done
      rolfus earned a badge
      Week One Done
    • One Month Later
      Leroy Jethro Gibbs earned a badge
      One Month Later
  • Popular Contributors

    1. 1
      +primortal
      500
    2. 2
      +Edouard
      194
    3. 3
      PsYcHoKiLLa
      125
    4. 4
      Steven P.
      87
    5. 5
      neufuse
      73
  • Tell a friend

    Love Neowin? Tell a friend!