Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can I restore from .BAK file without any other
Message
General information
Forum:
Microsoft SQL Server
Category:
Backups
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01436834
Message ID:
01436836
Views:
80
This message has been marked as the solution to the initial question of the thread.
>Hi,
>
>I have downloaded a source code to a book that I am studying. The downloaded source has a .BAK file (backup of a database). But when I go to the SQL Server 2005 Management Studio and go to Restore command I need to specify to which database I want to restore. And, of course, I don't have an earlier (or any) verison of this database. Therefore, how do I restore a database from .BAK file without having a database?
>
>TIA,


Start SSMS.
In Object Explorer, right click on Databases and select Restore Database.
IN "To Database" write the name of the database (new one).

Other way.
Just create a DB with the same name before restore the backup file.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform