Snapshot of SQL Server 7 database

[erikita21]

Does anyone know of a script I can run to take a snapshot of a SQL server 7 database? If not what is the best way to go about getting a snapshot of the db?

Thanks!

[Ray Miao]

Need schema, data or both? Script db for schema, bcp for data, and backup for both.


------------
erikita21 at 11/2/01 8:13:47 AM

Does anyone know of a script I can run to take a snapshot of a SQL server 7 database? If not what is the best way to go about getting a snapshot of the db?

Thanks!