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 2008 Forums
 SQL Server Administration (2008)
 SQL server restore 2005 to SQL server 2008

Author  Topic 

sridharsridhar
Starting Member

21 Posts

Posted - 2013-01-09 : 01:02:09
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)

17689 Posts

Posted - 2013-01-09 : 01:17:58
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
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

sridharsridhar
Starting Member

21 Posts

Posted - 2013-01-09 : 01:40:58
Khtan Thanks a lot for your Quick Reply

sridhar
Go to Top of Page

sridharsridhar
Starting Member

21 Posts

Posted - 2013-01-12 : 08:09:14
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

21 Posts

Posted - 2013-01-12 : 09:43:40
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

160 Posts

Posted - 2013-01-15 : 07:27:17
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

21 Posts

Posted - 2013-01-16 : 16:26:34
thanks
now able to restore backup

sridhar
Go to Top of Page
   

- Advertisement -