Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restore database to different server
Message
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00818368
Message ID:
00818404
Views:
17
It was telling me to restore with format or something like that. I actually took the backup from a daily backup from the server. When I tried to backup the database just now it would not let me do it. It wanted me to backup with format to create a new media set. So, I exported the data to a new database with a different name and copied over the stored procedures and made a backup of that. I guess that should work when I get home.

Thanks
Jeff

>If you right click on "Databases" or a database already created and select "All Tasks > Restore Database" you dont have to create the database a head of time. Just type in what you want to call the new restored database.
>
>What error are you getting?
>
>>I made a backup of a database at work and attempted to restore it on a different server, at home actually. Is there a procedure I should follow? I keep getting error. I created a database with the same name as the one at work hoping to fake it out.
>>
>>Thanks
>>Jeff
Previous
Reply
Map
View

Click here to load this message in the networking platform