November 4, 2010 at 10:48 am
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
November 4, 2010 at 11:29 am
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[/url]
Learn Extended Events
November 5, 2010 at 6:28 am
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?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply