Here are steps recommended by Microsoft on backing up and restoring a SQL database: http://msdn.microsoft.com/en-us/library/ms187510.aspx Please consult Microsoft for more specific details or questions on SQL database backup and restores.