SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Understanding SQL Server Database Restore Process

Data is a critical asset for an organization to keep information about their customers, inventory, products, purchasing, and financial stocks. It is our responsibility as a database administrator (DBA) to ensure that the information in the databases is available all the time.

Although, a SQL Server various high-availability solutions tries to keep the business data online, a database backup plan is critical to protect the business related data. It is very critical for companies to have an efficient database backup plan because databases backups allow them recovery from data corrupting event, data loss, or as part of a disaster recovery plan to cover the total failure of the primary data center. Moreover, the good database backup strategy also reduces data recovery time.

Checkout my article here, in which I discussed about SQL Server database restore and recovery process, available SQL Server database restore options, and how to verify a backups before restore. In the end, I compared and contrasted complete restore, piecemeal restore, file restore, page restore, and recovery only.

This article is published onĀ SSWUG.org.

Basit's SQL Server Tips

Basit Farooq is a Lead Database Administrator, Trainer and Technical Author. He has more than a decade of IT experience in development, technical training and database administration on Microsoft SQL Server platforms. Basit has authored numerous SQL Server technical articles, and developed and implemented many successful database infrastructure, data warehouse and business intelligence projects. He holds a master's degree in computer science from London Metropolitan University, and industry standard certifications from Microsoft, Sun, Cisco, Brainbench, Prosoft and APM, including MCITP Database Administrator 2008, MCITP Database Administrator 2005, MCDBA SQL Server 2000 and MCTS .NET Framework 2.0 Web Applications.


Leave a comment on the original post [basitaalishan.com, opens in a new window]

Loading comments...