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 restore 2005 to SQL server 2008		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sridharsridhar
Starting Member

India
12 Posts
Posted - 01/09/2013 :  01:02:09  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

sridhar

khtan
In (Som, Ni, Yak)

Singapore
16746 Posts
Posted - 01/09/2013 :  01:17:58  Show Profile  Reply with Quote
Just restore as per normal. No special treatment is required. It will be automatically converted to the 2008 version.

However, the reverse is not possible. You can't restore a 2008 backup on a 2005.


KH
Time is always against us
Go to Top of Page

sridharsridhar
Starting Member

India
12 Posts
Posted - 01/09/2013 :  01:40:58  Show Profile  Reply with Quote
Khtan Thanks a lot for your Quick Reply

sridhar
Go to Top of Page

sridharsridhar
Starting Member

India
12 Posts
Posted - 01/12/2013 :  08:09:14  Show Profile  Reply with Quote
Hi Khtan
We have faced this issue while restoring SQL Server 2005 to SQL Server 2008

Resore failed for the server

System.Data.sqlclient.sqlError:Exclusive acess could not be obtained because the database is in use (Microsoft.Sqlserver.smo)

sridhar
Go to Top of Page

sridharsridhar
Starting Member

India
12 Posts
Posted - 01/12/2013 :  09:43:40  Show Profile  Reply with Quote
Hi
I have stopped all the application which have access to the database and tryed to restore it worked
but know its showing below message after sucessfully restored

"Database samplefdm is not accessible (Object Explorer)"

sridhar
Go to Top of Page

srimami
Posting Yak Master

152 Posts
Posted - 01/15/2013 :  07:27:17  Show Profile  Reply with Quote
Can you drop this database, restore it all fresh again to see if you get the same error message. Ideally, it won't.
Go to Top of Page

sridharsridhar
Starting Member

India
12 Posts
Posted - 01/16/2013 :  16:26:34  Show Profile  Reply with Quote
thanks
now able to restore backup

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