How To: A quick and easy way to move your SQL databases
posted by Luigi Petrolito in Best Practices on Aug 30, 2011
We’re often asked about how to move SQL databases from one server to another. Here are some quick and easy guidelines to help out you out.
Assuming you already installed SQL on your new server, your next step would be to start detaching the database from the SQL application on the old server.
- Stop all services belonging to 3rd party applications that use the database
- Go to SQL Manager
- Right-click on the database name
- Select Tasks > Detach
At this point you will have .MDF and .LDF files in the C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data folder. You can now move them to the new server where you have SQL installed in that same folder location.
You are now ready to attach the database to the new SQL server:
- Go to SQL Manager
- Right-click on the database
- Select Tasks > Attach (below)
- Click on Add and browse to your database databasename.MDB file.
It might take a few minutes for the database to attach. Once this is done you may now point your 3rd party applications to the database on the new server.
Share this article
|
|
|||
| Share |
|
|
Comments
More Recent News
Writing technical doc
Writing technical documentation should not be a complicated procedure. Remember, you’re not writing a novel. You want to communicate information and procedures in a clear and concise fashion. Sometimes basic short... (May 15, 2012)
Go Postal on Spam
You get it at the office. You get it at home. Postal spam a.k.a. junk mail. Since the late 1800’s flyers, ad-mail, unsolicited magazines and pamphlets have been cluttering up people’s mailboxes and, now, people’s... (May 09, 2012)
Single installer to deploy
With the advent of 64-bit hardware, Microsoft has released a 64-bit version of Windows to leverage the capabilities of these hardware platforms. The new Version has the advantages of addressing more than 4 GB of... (May 03, 2012)
