Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jogin malathi
Posting Yak Master
117 Posts |
 Posted - 2007-01-18 : 07:37:18
|
| Hi All,here i had a problem to restore the database from backp filefirst i had taken the backp of my reqired databaseafter that i want to restore the backp database into newly created databaseit is not allowing showing msg as database is in useif i delete the database frm which i had taken the backp it is allowingBut i don't want to delete the databaseALL THE PROCESS IS DONE IN SQL SERVER 2005Malathi Rao |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-01-18 : 07:41:39
|
| You have to make sure there aer no users in the database to do a restore.Make sure you are not connected to the datbase when you do the restore.You can see the users in the database via management studio or master..sysprocesses and kill them if necessary.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
madhuotp
Yak Posting Veteran
78 Posts |
Posted - 2007-01-18 : 08:10:52
|
| could u pse post u r restoration script (if u r restoring through script)....madhu |
|
|
|
jogin malathi
Posting Yak Master
117 Posts |
Posted - 2007-01-18 : 08:33:43
|
| iam tacking backp of my database and restoring it thr management studioMalathi Rao |
|
|
|
|
|
|
Database Backup