VERY IMPORTANT…Copying a SQL 2005 database (.mdf and .ldf file) without previously detaching the database, can cause the database to become corrupt and unusable.
Unlike SQL 2000, it is possible to copy or delete SQL 2005 database files without previously detaching the database. You must take extreme caution to prevent this from occurring. You MUST detach the database, prior to copying the database files.
Note: In case of a disaster, it is very important to have a recent backup of your databases.
This content is restricted to site members. If you are an existing user, please login. New users may register below.