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
 General SQL Server Forums
 New to SQL Server Programming
 Can I move from using sql 2000 to sql 2005

Author  Topic 

ann06
Posting Yak Master

171 Posts

Posted - 2009-11-15 : 03:13:28
Is there a way from restoring my databases from sql 2000 to sql 2005 using backup and restore? i have windows server 2003 sp1

thanksss

senthil_nagore
Master Smack Fu Yak Hacker

1007 Posts

Posted - 2009-11-15 : 07:19:25
You can take take Script and run it in 2005, but data can't be copied!

Senthil.C
------------------------------------------------------
[Microsoft][ODBC SQL Server Driver]Operation canceled

http://senthilnagore.blogspot.com/
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2009-11-15 : 07:24:54
Yes. You can backup the SQL 2000 database and restore it in a SQL 2005 Server


KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page
   

- Advertisement -