We support MS SQL Server 2005 Express. There is one production database on it. Our customer needs a copy of that database under a different name for testing purposes. There is no Copy Database task in Express and some people suggest BACKUP/RESTORE. Can anyone provide a cookbook recipe for doing that? Should we use COPY ONLY or what else to keep in mind so that the original database stays up and happy?
asked Oct 23, 2009 at 06:51 AM in Default
From Books Online (the help file)
answered Oct 23, 2009 at 07:42 AM
You are right to be considering COPY ONLY if the production database is set to Full Recovery mode and log backups are occuring frequently.
As MSDN/BOL states
The syntax for this is
If taking a backup isn't going to affect the backup strategy in place, then you can follow the steps that Stuart Ainsworth gave.
answered Oct 23, 2009 at 12:02 PM
Kev Riley ♦♦