ITBeginner

Yesterday I attempt to backup and restore my database I use sql server 2005 version developer . I want to copy database “DataTest” to new database name “MyDB” I try two ways first I backup “DataTest” then restore to “MyDB” but when restore sql server have error . Second restore database “DataTest” to “MyDb” and but not work I attempt about 4 hours I google then found answer then I can restore.

How I solve problem ?

When I backup sql server backup two files are:

C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataDataTest.mdf

C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataDataTest_log.ldf

C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMyDB.mdf C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataMyDB_log.ldf

This entry was posted on Tuesday, July 8th, 2008 at 9:44 am and is filed under SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.