SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 SQL Mangement Studio Restore Database error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

derach2000
Starting Member

Bosnia and Herzegovina
35 Posts

Posted - 02/07/2013 :  04:40:24  Show Profile  Reply with Quote
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
52317 Posts

Posted - 02/07/2013 :  04:54:21  Show Profile  Reply with Quote
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/

Go to Top of Page

derach2000
Starting Member

Bosnia and Herzegovina
35 Posts

Posted - 02/07/2013 :  09:54:20  Show Profile  Reply with Quote
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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 02/07/2013 :  23:21:15  Show Profile  Reply with Quote
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/

Go to Top of Page

derach2000
Starting Member

Bosnia and Herzegovina
35 Posts

Posted - 02/08/2013 :  06:37:38  Show Profile  Reply with Quote
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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 02/08/2013 :  07:09:56  Show Profile  Reply with Quote
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/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000