CODEWITHSUNDEEP
sql-server
Muhammad Sharjeel Ahsan
Muhammad Sharjeel Ahsan

Reputation: 672

Steps of Database Backup and Restore to Other Server

I have a couple of Databases which I need to deploy from Production Servers to Live Servers.

What I am doing is, before creating Backup, I rebuild the indexes and Update Statistics, then make backup and send it to Live.

Is that a good practice, can some one advice me in this regard

Thanks

Upvotes: 0

Views: 68

Answers (1)

user1998428
user1998428

Reputation: 86

Rebuilding indexes and update statistics, then shrinking make the database server busy, which may respond to your users as database server busy, or slow down their queries. Space is not an issue now a days so increase your database server drives.

Thanks

Upvotes: 1

Related Questions