Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Best way to copy SQL database?
- Thread starter jruiseco
- Start date
jruiseco,
I don't know if this is the 'best' way, but what I've done in the past is shut down SQL Server and then zip the .mdf and .ldf. The zipping alone will probably take you an hour at least, and probably more depending upon the size of your database. When you're finished zipping up the file, don't forget to start SQL server again. Then just FTP it where ever you want.
earme
I don't know if this is the 'best' way, but what I've done in the past is shut down SQL Server and then zip the .mdf and .ldf. The zipping alone will probably take you an hour at least, and probably more depending upon the size of your database. When you're finished zipping up the file, don't forget to start SQL server again. Then just FTP it where ever you want.
earme
- Thread starter
- #3
- Thread starter
- #4
Once you have the files on another pc you can unzip the files anywhere you like and then from Enterprise Manager right click on the Databases folder and choose 'Attach Database'. It will ask for the location of the mdf file and give you the option to attach it as a different name.
After this you should see it under the database folder and be able to look at it exactly like you did on the other pc. And you should be good to go.
earme
After this you should see it under the database folder and be able to look at it exactly like you did on the other pc. And you should be good to go.
earme
- Thread starter
- #6
- Status
Similar threads
- Locked
- Question
- Locked
- Question
