Hi,
I have SQL Server 2000 running on an NT server.
I have set up another server also running SQL Server 2000 under Windows 2000.
I want to use the 2000 server for test purposes. I have a backup of the existing database on the NT server.
How do I go about importing the backup from the existing database on the NT server into my test server? Do I need to import the following databases ?
master
msdb
actual database
I have tried starting SQL in single user mode and trying to use the restore command to import the master database but this fails. What is the correct procedure for importing a database?
I have SQL Server 2000 running on an NT server.
I have set up another server also running SQL Server 2000 under Windows 2000.
I want to use the 2000 server for test purposes. I have a backup of the existing database on the NT server.
How do I go about importing the backup from the existing database on the NT server into my test server? Do I need to import the following databases ?
master
msdb
actual database
I have tried starting SQL in single user mode and trying to use the restore command to import the master database but this fails. What is the correct procedure for importing a database?