Copy database


I’m in SQL Ent. man (8.0) wizzard, trying to copy a database. It wont let me do it due to users accessing the source base. Hey! I’m just READing the data. Whats the big deal?

Is there an other copy option to help me out beside the scheduler?


The SQL copy database wizard detaches the DB, copies the files to new location, the re-attaches the DB. This is why no users can be attached.

Another option would be an SQL backup and re-directed restore.

Thanx babrown! I’ll try that.