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.
| Author |
Topic |
|
Hoffler1
Starting Member
2 Posts |
 Posted - 2009-08-24 : 12:06:35
|
| Hi Folks,I have been asked to transferr a Database which up until now has been working away merrily on MSDE to a new server which is using sql version 8.I have no experience in working with sql and need assistance.Would anybody be able to point me in the right direction with regards to a step by step procedure on this?Thanks in Advance.Robert. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-08-24 : 14:07:34
|
| "sql version 8"? Do you mean SQL Server 2000?If so, make a backup of your MSDE database, and restore on the SQL Server 2000.CODO ERGO SUM |
 |
|
|
Hoffler1
Starting Member
2 Posts |
Posted - 2009-08-25 : 11:34:16
|
That's it???Cool! I'll try it and let you know how it goes.Thanks a million!!  |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2009-08-25 : 11:51:12
|
| There are some other things that you have to do, like creating logins on the new server that have access to the database, but for the most part, that's it.It probably a good idea to update statistics on the database after is restored, especially for a different version of SQL Server.CODO ERGO SUM |
|
|
|
|
|
|
Transferring a Database from MSDE to sql version 8