Upgradation of Database in SQL Server with Attach and Deattach

Upgrade of Database in SQL Server with attach and deattach option

1. Check the location of datafiles of database.

Right click on database and go to properties and check datafile location.

2. Shutdown SQL Server 2000 (express) service on old machine.

Stop all the Services of SQL Server in services.msc.

3. Move datafiles (mydatabase.mdf and mydatabase.ldf) to new machine.

cp paste the datafile which need to copy.

4. Run SQL Server Management Studio 2008.

5. Connect to local server of sql Server 2008.

6. Attach datafiles to database.

Right click on databases and go to attach option.

7  Attach datafiles to database.

Give the location of mdf files present for database and put the name of database.

8.  Change the compatibility level of database to SQL 2008 (100).

Once done, change compatibility level of database and configure the backup of the database.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.