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?