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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-25 : 09:48:36
|
| Hunter Bungay writes "Hello! I've just purchased a new server hardware platform to host an existing SQL 7.0 Database on.Problem: How do I move the existing SQL 7.0 database over to the new server keeping in mind that the new server has different drive setup then the existing/old SQL7.0 server that is currently being used for production.I've checked out the article posted in your Installation Forum Titled "Moving SQL Server to a New Server" posted by Graz, while this does address some issues... it does not cover the fact that the drive arrangement in the new server is different from the old server as well as the fact that that the old server is named a different name than the new server and the old server is to reamain in service as an "Backup" (Mind you, the old server will be only in service as long as it takes me to get the new server up and running with the migrated SQL dBase)Any ideas or assistance in this matter will be greatly appreciated! Thanks in advance.Hunter Bungay" |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-25 : 10:56:24
|
| INF: Moving SQL Server Databases to a New Location with Detach/Attach[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071[/url]INF: How To Transfer Logins and Passwords Between SQL Servers[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133[/url]HOW TO: Resolve Permission Issues When You Move a Database Between Servers That Are Running SQL Server[url]http://support.microsoft.com/default.aspx?scid=kb;en-us;Q240872[/url]HTHJasper Smith |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-10-25 : 19:44:33
|
| Then there are always these articles:[url]http://www.sqlteam.com/item.asp?ItemID=9066[/url][url]http://www.sqlteam.com/item.asp?ItemID=9465[/url]which containg methods that can be used even if you're not upsizing to SQL 2000. |
|
|
|
|
|
|
Moving SQL 7.0 Database to a new Server