Data Analysts and Consultants in SQl Server, MS Access, Crystal Reports and SQL Reporting Services for Healthcare and all businesses
Wednesday September 8th 2010

Insider

Archives

‘Restoring .bak File’ Archives

Restore backup of database (.bak) using Sql Server 2005

If you intend to create a back up of your database in Server A and restore it on a Server B, here's how to go about it. Create a .bak file (Open SSMS > Database > Right Click your database > Tasks > BackUp > Specify the destination). To do it using script, check my blog over here. Once the .bak is created, copy this file from [...]