skuehner
June 9th, 2006, 04:32 PM
How can I copy a database in SQLServerExpress? There is no "copy database" in "Tasks"...
Click to See Complete Forum and Search --> : Copy database SQLEXpress
Shuja Ali
June 10th, 2006, 06:51 AM
MDF files in SQL Express are just like regular files. SQL Express automatically attaches and dettahces the MDF file. It will attach the MDF file when a connection is openeed to that database and once the last opened connection is closed it will dettach the database again.
So this means you can use a simple Xcopy/Copy to copy the specific MDF file to a new folder or new machine.
Take a look at Xcopy Deployment (http://msdn2.microsoft.com/en-us/library/ms165716.aspx)
So this means you can use a simple Xcopy/Copy to copy the specific MDF file to a new folder or new machine.
Take a look at Xcopy Deployment (http://msdn2.microsoft.com/en-us/library/ms165716.aspx)
codeguru.com
Copyright Internet.com Inc., All Rights Reserved.
Copyright Internet.com Inc., All Rights Reserved.