Database Restor
-
Hi everyone! I'm currently learning Database Administration and trying to play with database backup and restore. I have created a database that I am using to try what I've learnt so far. I'm trying to restore a backup database but I always get an error that '... Restore failed on server ...' when I still have the database on the server. But if I delete the database from the server and perform the restore, everything works fine. However, when I create a backup of 'AdventureWorks' database and perform the restore, I do not encounter any problem whether 'AdventureWorks' database still exists on the server or not. I'm thinking the problem be occuring from some database properties I do not know. I need help on how to solve this problem of restoring the backup when the database still exists on the server as it works with 'AdventureWorks'. Thanks in advance.
-
Hi everyone! I'm currently learning Database Administration and trying to play with database backup and restore. I have created a database that I am using to try what I've learnt so far. I'm trying to restore a backup database but I always get an error that '... Restore failed on server ...' when I still have the database on the server. But if I delete the database from the server and perform the restore, everything works fine. However, when I create a backup of 'AdventureWorks' database and perform the restore, I do not encounter any problem whether 'AdventureWorks' database still exists on the server or not. I'm thinking the problem be occuring from some database properties I do not know. I need help on how to solve this problem of restoring the backup when the database still exists on the server as it works with 'AdventureWorks'. Thanks in advance.
Hi, When you are doing a SQL database restore, are you over riding the current database? 1.In the restore window, select the database source for backup. 2.select options from the left pane. 3.check 'over write the existing database' check box. 4.Restore. Hope this helps.
-Manognya __________________________________________________ $ God gives what is best.Not what all you wish :)
-
Hi everyone! I'm currently learning Database Administration and trying to play with database backup and restore. I have created a database that I am using to try what I've learnt so far. I'm trying to restore a backup database but I always get an error that '... Restore failed on server ...' when I still have the database on the server. But if I delete the database from the server and perform the restore, everything works fine. However, when I create a backup of 'AdventureWorks' database and perform the restore, I do not encounter any problem whether 'AdventureWorks' database still exists on the server or not. I'm thinking the problem be occuring from some database properties I do not know. I need help on how to solve this problem of restoring the backup when the database still exists on the server as it works with 'AdventureWorks'. Thanks in advance.