SQL 2005 TO SQL 2008 - SQL Server Forums

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

Transact-SQL (2008)

SQL 2005 TO SQL 2008

Author

Topic

smitha
Posting Yak Master

100 Posts

Posted - 2010-01-29 : 07:31:36

Hi,
I have sql 2005 database. Now I want to transfer the database contents to sql 2008 database.
If I take the backup from 2005 and restore it in 2008, will it work?

Smitha

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-01-29 : 07:51:27

quote:
Originally posted by smitha

Hi,
I have sql 2005 database. Now I want to transfer the database contents to sql 2008 database.
If I take the backup from 2005 and restore it in 2008, will it work?

Smitha

Yes. Did you try it?

Madhivanan

Failing to plan is Planning to fail

smitha
Posting Yak Master

100 Posts

Posted - 2010-01-30 : 01:52:09

No, I hav'nt tried. But before proceeding with that activity, I want confirmation.

Smitha

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2010-01-30 : 02:01:53

Hi

There should be no problem.

IF you want to roll back any uncommitted transactions.

RESTORE DATABASE [DBNAME] WITH RECOVERY

Related documents:

RESTORE (Transact-SQL)
http://msdn.microsoft.com/en-us/library/ms186858.aspx

Copying Databases with Backup and Restore
http://msdn.microsoft.com/en-us/library/ms190436.aspx

-------------------------
[R][A][J]

Kristen
Test

22859 Posts

Posted - 2010-01-30 : 04:46:33

"If I take the backup from 2005 and restore it in 2008, will it work?"

Here's a thread discussion recommended processes for migrating from SQL 2005 to SQL 2008

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources