Logistics Salon Logistics Salon Forum

This = = can ~ do ~ arrive

All raccoons care about each other.

All parties. Miankeyi

image.baidu/www.Lv-x.net? Tai Caliso

-

In the enterprise-level upgrade operation, Microsoft gives the safest advice:

Pre-preparation:

1, new installation of SQL2008R2 instance

2. Back up the database in the original database instance.

3. Restore the backup in the SQL2008R2 instance.

4. After rigorous testing, we decided to upgrade the database, because each database version is different.

Actual upgrade:

1, new installation of SQL2008R2 instance

2. Deactivate the original database instance and back up the database file (copy backup).

3. Attach the original database file to the SQL2008R2 instance.

4. Keep the original database version running, stabilize it for a period of time, and then upgrade to the new database version.