Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Scheduled Backup and Restore to a different server Expand / Collapse
Author
Message
Posted Thursday, November 4, 2010 10:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 29, 2010 7:04 AM
Points: 2, Visits: 8
Hi all, I was after some free advice.

I'm fairly new to SQL and have been tasked to solve a little problem.

I need to backup a database from our LIVE server and restore to our DEV server on a weekly basis. Both servers are SQL2005.

We have Backup Exec 2010 which performs a daily full SQL database backup and frequent log backups, it must take place before this on a Saturday.

Can anyone give me some suggestions on the best way to do this?

Kind Regards,

Andy
Post #1016033
Posted Thursday, November 4, 2010 11:29 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Yesterday @ 10:32 PM
Points: 18,055, Visits: 16,087
I have scripted the backup and restore from one server to another. We use native SQL for the backup and for the restore. I restore from a file on the disk on one server to a different server and this is done on a nightly basis - immediately following the backup of said database.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1016071
Posted Friday, November 5, 2010 6:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 29, 2010 7:04 AM
Points: 2, Visits: 8
Any chance you can send me a copy of the SQL code that you run so I can have a crack at tweaking it to fit our needs?
Post #1016481
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse