convert database

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
13 years ago
I downloaded a backup copy of my database now I want to convert this backup copy that end with the extension .BAK into a working copy for my local server. Can someone tell how to convert a SQL database.
0
13 years ago
No such thing as a "Convert". That file is a backup file. You restore that file either over an existing database or allow SQL Server to create a new database from that file. I find it easier and more simple to allow SQL to overwrite an existing database.

Look up
RESTORE DATABASE
in the SQL Books Online.

Andrew SQLDBA
0
13 years ago
Thank's
0
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.