 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / March 2008How to copy database from one server to another
I have a database on a SQL Server 2005 Express. I want to copy this database along with all its data into another server which is a SQL Server 2005 (full edition). I can't seem to figure out an easy way to do this. I tried backing up and restoring database but it told me that the backup file is for another database. What's an easy and good way to accomplish this? Check out RESTORE DATABASE in the BOL. Use the REPLACE option.  SignatureTom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS SQL Server MVP Toronto, ON Canada https://mvp.support.microsoft.com/profile/Tom.Moreau I have a database on a SQL Server 2005 Express. I want to copy this database along with all its data into another server which is a SQL Server 2005 (full edition). I can't seem to figure out an easy way to do this. I tried backing up and restoring database but it told me that the backup file is for another database. What's an easy and good way to accomplish this? You can also check out the Copy Database wizard and detach/attach db too. SignatureKevin G. Boles Indicium Resources, Inc. SQL Server MVP kgboles a earthlink dt net >I have a database on a SQL Server 2005 Express. I want to copy this > database along with all its data into another server which is a SQL [quoted text clipped - 3 lines] > > What's an easy and good way to accomplish this? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.