Planning to move data on new databse server?

20 pts.
Tags:
Application Server
Database servers
Microsoft SQL Server 2000
Well i m working in MNC As a Network admin actually we have one server having data & application so both our application and database on same server & now we are facing some problem on it so we plan to seperate database server & application if any body has a plan or he/she know how move our database & application. currently we are using its sql server 2000 more then 2 G.B so give me plan for this.

Answer Wiki

Thanks. We'll let you know when a new response is added.

Moving your database shouldn’t be all that hard. It sounds like you are planning on moving the application from the current server to a third server which makes it easier to do.

1. Install SQL 2000 on the new server. You will want to patch it to the same patch level that the current server is running or higher. I recommend that you patch the server to the highest patch level, but check with the application vendor to be sure. You can use the <a href=”http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx”>SQL Server Version Database</a> to find the correct patches to install.

2. Use <a href=”http://support.microsoft.com/kb/246133″>sp_help_revlogin</a> on the old SQL Server to script out all the logins and passwords are recreate them on the new SQL Server.

3. Turn off the application on the old server (stop the services, turn off the web server, etc).

4. Detach the database from the old SQL Server using either SQL Server Enterprise Manager or the sp_detach_db stored procedure. If using the SQL Server Enterprise Manager right click on the database and select detach.

5. Copy the physical database files from the old SQL Server to the new SQL Server.

6. In SQL Server Enterprise Manager right click on the databases container and select Attach database. Navigate to the correct folder where you placed the MDF file and select it. Ensure that the path which displays to the LDF is correct. If it is not, then correct it. Press OK when ready.

7a. Install the application on it’s new server. When it asks for the database server give it the name of the server to just attached the database to. The username and password will be the same.

7b. If you are not moving the application to another server then you will want to find the configuration files for the application and edit them so that they point to the now remote SQL Server. You may need to call the application vendor in order to find these.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following