| Author |
 Topic  |
|
|
derach2000
Starting Member
Bosnia and Herzegovina
35 Posts |
 Posted - 02/07/2013 : 04:40:24
|
Hi,
I'v been having problems with databse restore using management studio 2012.
I choose the source device, change the destination db name.
I'v noticed, on the Files tab, Restore As path contain the
device sour db name, not the new destination db name.
Then I change the path manually for mdf and ldf.
I get an error, database in use.
It's like it is trying to overwrite the existing databse files.
Any ideas?
Armin Mahmutovic
student of Clarion,C#,Crystal and SQL martial arts |
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47023 Posts |
Posted - 02/07/2013 : 04:54:21
|
are you trying to restore an existing db with new backup or are you trying to create a new db from backup?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
|
derach2000
Starting Member
Bosnia and Herzegovina
35 Posts |
Posted - 02/07/2013 : 09:54:20
|
i'm trying to create new db from the back up file
of an existing db
i also have, sql 2008 r2, sql 2008 and sql 2005
and they all behaive normally
when i choose the name for the new db
it automatically updates the database location path with the new name
Armin Mahmutovic
student of Clarion,C#,Crystal and SQL martial arts |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47023 Posts |
Posted - 02/07/2013 : 23:21:15
|
you need to browse the path of backup file and give it new db name and it will automatically create new db from backup
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
derach2000
Starting Member
Bosnia and Herzegovina
35 Posts |
Posted - 02/08/2013 : 06:37:38
|
of course i browse for backu file
give the new db name
but it still is trying to overwrite the existing database files
from which the backup was made
i ended up doing the job using a script
Armin Mahmutovic
student of Clarion,C#,Crystal and SQL martial arts |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47023 Posts |
Posted - 02/08/2013 : 07:09:56
|
quote:
Originally posted by derach2000
of course i browse for backu file
give the new db name
but it still is trying to overwrite the existing database files
from which the backup was made
i ended up doing the job using a script
Armin Mahmutovic
student of Clarion,C#,Crystal and SQL martial arts
Are you trying to do it on same server where you've original db?
Also did you give a different name for new db?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
| |
Topic |
|
SQL Mangement Studio Restore Database error
