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 2008 Forums
 SQL Server Administration (2008)
 SQL server 2008 Backup Restoring Error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sridharsridhar
Starting Member

India
21 Posts

Posted - 12/06/2012 :  04:18:12  Show Profile  Reply with Quote
I have taken database (Database Name hyperionepm) backup from SQL server 2008 and when i am trying to restore the backup to the other database (Database name FDM_MIGRATION) in the same SQL Server 2008. it showing error for backup i have used this path right clicking Database (hyperionepm) -Tasks - Backup . and i have tryed to restore by right click on Database (FDM_Migration)- Tasks - for Restore Option this is the way i have taken backup and tryed to restore. it showing error as below can anyone tell the way to restore backup


Restore failed for server’ HYPERIONEPM’,(Microsoft .SqlServer.SmoExtended)

**Additional Information
System.Data.SqlClient.SQlError:Thefile’C:\ProgramFiles\Microsoft SQL
Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\hyperionepm.mdf’cannot be overwritten.It is
Being used by database ‘hyperionepm’.(Microsoft.SqlServer.Smo)**


sridhar

johnson_ef
Starting Member

India
16 Posts

Posted - 12/12/2012 :  03:28:18  Show Profile  Reply with Quote
Hi Sridhar,

This error is coming because, you are using same path to restore db with different name. Though the name of the DB is different, the data,log files are same.

You can do, either, change the destination path (in this case ’C:\ProgramFiles\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\FDM_MIGRATION\ ) so SQL will not find an existing file there
or
while restoring, change the data and log file name '\hyperionepm.mdf' to 'FDM_MIGRATION_data.mdf'

I would prefer the second method, because, this will avoid confusion later, which files are belongs to which Database.
-Johnson
Go to Top of Page

sridharsridhar
Starting Member

India
21 Posts

Posted - 12/17/2012 :  07:00:14  Show Profile  Reply with Quote
Thanks a lot Johnson

sridhar
Go to Top of Page

sridharsridhar
Starting Member

India
21 Posts

Posted - 01/09/2013 :  00:59:50  Show Profile  Reply with Quote
Hi All,

Can you tell me how to restore the Database backup of SQL server 2005 to SQL server 2008.

sridhar
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.05 seconds. Powered By: Snitz Forums 2000