Copy from Production Database to a test database

Can anyone tell me how I can copy from the Production
database to the test database?
Thanks
Rob,
if the server names are identical (different networks) then restoring with KEEP_REPLICATION should retain the replication settings. If the server anems are different then script out the publications on the live server, edit the scripts to replace the serv
er names and any job owners which are using windows logins, then apply the script on the test server.
HTH,
Paul Ibison
|||Hi,
1. Backup the production database using (BACKUP DATABASE command)
2. COpy the backup file to test server
3. Restore the database in test server (RESTORE DATABASE)
See Backup and Restore commad in books online.
Note:
you can also detach and attach databases. It is fast but require down time
in production.
Thanks
Hari
MCDBA
"Paul Ibison" <PaulIbison@.discussions.microsoft.com> wrote in message
news:3BDF642C-9BDC-4FD6-AFC5-E5F200980923@.microsoft.com...
> Rob,
> if the server names are identical (different networks) then restoring with
KEEP_REPLICATION should retain the replication settings. If the server anems
are different then script out the publications on the live server, edit the
scripts to replace the server names and any job owners which are using
windows logins, then apply the script on the test server.
> HTH,
> Paul Ibison
>