Solved

MSSQL Remote Backups

Posted on 2013-12-05
5
239 Views
Last Modified: 2013-12-05
Hi,

We have one main SQL Enterprise server and several SQL Express servers dotted around our company. Is it possible to use the main SQL Enterprise server to schedule backups for the SQL Express servers?

I am currently using SQL Server Agent to schedule the backups of the main SQL Databases (local) but I would also like to schedule remote SQL databases from this server. How would I script the backups..?

Thanks, Greg
0
Comment
Question by:spen_lang
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 13

Expert Comment

by:Felix Leven
ID: 39697833
Thats a main difference between Enterprise/Express. There are free 3rd Party tools to do Express backups or you can shutdown express servces, do a filebackup of the express DB and start the Express SQL server again.
0
 

Author Comment

by:spen_lang
ID: 39697974
Can I not backup my express database using my enterprise database on a remote server?
0
 
LVL 13

Expert Comment

by:Felix Leven
ID: 39697988
No, migrate (my recommendation) or daily import and backup.

I dont like to see any Express versions in any productive corporate environment, its hackers first or second choice in a Microsoft network.
0
 
LVL 13

Accepted Solution

by:
Felix Leven earned 500 total points
ID: 39697996
How to schedule and automate backups of SQL Server databases in SQL Server Express
http://support.microsoft.com/kb/2019698/en-us

anyway the local pc has to stay up and running when the backup is scheduled.
0
 
LVL 1

Expert Comment

by:mike706
ID: 39698087
Have a look at this
http://ola.hallengren.com/

Use this script to backup SQLExpress instances. Run the scripts from a command prompt with sqlcmd.exe and/or Schedule them in Task Scheduler.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question