General information
Forum:
Microsoft SQL Server
Category:
Database management
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only