Shulou(Shulou.com)05/31 Report--

This article is to share with you the content of an example analysis of the disk expansion of the mssql database of a third-class hospital in Shanghai. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

System: Windows server 2008r2 database: mssql 2008r2 data quantity: two libraries are about 30G respectively, and the rest are very small.

Due to the rapid development of hospital business, the original disk space will be full. At the request of the hospital, the database will be migrated from the old disk to the new disk.

According to the actual situation of the scene and discussing with the leader of the hospital information department, the plan is as follows:

1the two libraries of 30G are migrated with full addition of transaction logs, and the rest of the libraries with a small amount of data are migrated by separate attachments.

2. After changing the database to full mode, compress the x and y databases without stopping the business.

3. Restore the backup files to the new disk, using the restore with norecovery option.

4. Notify the hospital to stop the business and back up the transaction logs of the two libraries. The total estimated time is within 5min. Restore the transaction log to the new library, and then separate the old and new libraries at the same time.

5. Take the cluster service offline, put the disk online, copy all files except the DATA folder from the old disk to the new disk after changing the disk dependency, and copy all the system databases and databases with small amount of data and no backup in the DATA folder to the new disk, change the new disk letter to the old disk letter, and delete the current instance after changing the disk letter of the old disk.

6. Put the cluster service online and notify the business to open after verifying the database.

Fallback scheme: the new disk is offline, the original disk is online, and the cluster is online, and the business can be restored directly.

Note: the newly added disk needs to add a dependency in the SQL Server service attribute, otherwise an error will be reported.

Thank you for reading! This is the end of the article on "example analysis of disk expansion of mssql database in a third-class hospital in Shanghai". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.