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 |
|
michael999
Starting Member
9 Posts |
 Posted - 2011-12-02 : 04:58:27
|
| how do i copy a database from sql server to a file(s) so i can have my own backups etcthanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2011-12-02 : 05:07:24
|
1. Make a Full Backup file, and RESTORE that on the second machine2. DETACH the database, copy the database files to the second machine, reattach the database on both the Primary and Secondary machinesI always do (1) because:If re-attach doesn't work you don't have a database  so I would take a backup first anyway - in which case just copy the Backup file and restore that  You have to take the main database offline to DETACH it, and then it stays offline for however long it takes to copy. |
 |
|
|
|
|
|
backup