MSSQL Remote Backups

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
spen_langAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Felix LevenConnect With a Mentor Senior System and DatabaseadministratorCommented:
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
 
Felix LevenSenior System and DatabaseadministratorCommented:
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
 
spen_langAuthor Commented:
Can I not backup my express database using my enterprise database on a remote server?
0
 
Felix LevenSenior System and DatabaseadministratorCommented:
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
 
mike706Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.