SQL Mangement Studio Restore Database error

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.

All Forums

SQL Server 2012 Forums

SQL Server Administration (2012)

SQL Mangement Studio Restore Database error

Author

Topic

derach2000
Starting Member

37 Posts

Posted - 2013-02-07 : 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

52326 Posts

Posted - 2013-02-07 : 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

37 Posts

Posted - 2013-02-07 : 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

52326 Posts

Posted - 2013-02-07 : 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

37 Posts

Posted - 2013-02-08 : 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

52326 Posts

Posted - 2013-02-08 : 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/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources