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 |
|
sridharkamala
Starting Member
15 Posts |
 Posted - 2004-09-17 : 09:54:57
|
| Hello All!! I am new here. I am having questions in concern with an upgrade of SQL Server 2000. I have 4 databases on SQL Server 7.0 on Server A and i have a New server B. I have to install SQL server 2000 on new server and get 4 databases for Server A of SQL Server 7.0. I know i have couple of Options like Copy Database, Backup RecoverI want to Perform Backup and Recover option. My questions here is that when i take Full database backup (Dump), where should this dump be...on old server or new server. Do i have to create database on new server before restoring databases. File paths should be the same as my old server...In my case here on old server SQL Server is on C drive and on new server i have to move it to D drive... Is it ok if i can take a Full database Backup(Dump) to new server and restore.Thanks for any help!! |
|
|
chadmat
The Chadinator
1974 Posts |
|
|
sridharkamala
Starting Member
15 Posts |
Posted - 2004-09-20 : 08:18:14
|
| Chad, Thanks for your reply. The link you sent me was very helpful.Full database backup from old server need to be on Old server or new...Or does it matter where my backup is to restore it to new server?Thanks!!! |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2004-09-20 : 13:04:38
|
| Doesn't matter where. As long as you can access it from the new server.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
sridharkamala
Starting Member
15 Posts |
Posted - 2004-09-21 : 11:54:28
|
| Thanks! Chad |
|
|
|
|
|
|
Upgrade to SQL Server 2000 on new Server