Solved

MSSQL Remote Backups

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

746 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now