how to copy sql server database on same server
- by Sam
I've got a SQL Server 2008 and want to make a copy of a database so I've got a 2nd Version of the database for testing on the same server.
The database copy wizard is not able to copy the database, it always sends funny error Messages about missing objects (using SMO copy).
When I try to make a backup and restore it under a different database name it still keeps the file names of the original database and overrides this (crashing the original database).
So how do I copy a SQL database? Shutdown SQL Server, copy the physical files and attach them? Maybe a command line tool for database copy? Shouldn't there be an easy way to make a copy?