Re: copy a database from server to development

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 06/07/04 

Date: Mon, 7 Jun 2004 18:40:34 +0530

Hi,

There are 2 options:-

1. Detach and Attach database
2. Backup and Restore the database

1. Detach and Attach

   a. Use SP_DETACH_DB to detach the MDF and LDF files
   b. Copy the files to Destination server
   c. Use SP_ATTACH_DB to attach the databases

(Refer books online for information)

2. Backup and Restore

  a. Backup the source databases using BACKUP DATABASE command
  b. Copy the .BAK files to destination
  c. Restore the database using RESTORE DATABASE command

If you have only 1 or 2 users to syncronize then use the procedure
sp_change_users_login (Refer books online)

Thanks
Hari
MCDBA

"ken" <anonymous@discussions.microsoft.com> wrote in message
news:4D480E63-1DB3-43B0-814D-A1E4CF4DCD21@microsoft.com...
> Dear all,
> i want to copy a database from the sql enterprise server into my developer
edition for development, what is the most suitable methods for this?
>

Relevant Pages

  • Re: Restoring SQL Server Backups
    ... ORIGINAL BACKUP & RESTORE (MSDE Database) ... occurrenceof cachestore flush for the 'Object Plans' cachestore (part ...
    (microsoft.public.sqlserver.server)
  • Re: Restoring SQL Server Backups
    ... ORIGINAL BACKUP & RESTORE (MSDE Database) ... occurrenceof cachestore flush for the 'Object Plans' cachestore (part ...
    (microsoft.public.sqlserver.server)
  • Re: POINT IN TIME RESTORE
    ... This is what you should have done in order to do the restore as you wish: ... > 3- erase data ... > 5- restore database with norecovery ... The BACKUP DATABAE can of course be at an earlier point in time, ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Express backup
    ... I have an interesting situation with my website and I'm not sure if it would be better to ask here or a SQL forum. ... I cannot backup the MDF files because they are constantly in use. ... BACKUP DATABASE TO ... Are you running the mdf file from inside the web site (the auto attach to SQL Express option)? ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)