Solved

MSSQL Remote Backups

Posted on 2013-12-05
5
237 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
  • 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

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

685 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