Software

Ask something
Question Locked

MSSQL2000 copy database

0 helpful
2 replies

by trainer4063

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am setting up an off network test machine for testing some new projects using MSSQL2000. What I am looking for is a way to copy the current database, but NOT the data. OR create the schema script so I can use it in the new database server.

2 replies

by tony hopkinson

from Enterprise manager.
Right click on the database, it's onee of teh options.

You'll be presented with an impressive array of options.
Bear your security model in mind, if you are currently using integrated only, domain logons are going to cause you problems off the network.

This discussion is closed to new replies.