Maintaining Deployed Databases
After you build a database and deploy it into a production environment, you still might have to perform a variety of tasks to maintain that database. For example, you should back it up regularly. You might also have to perform periodic audits of the database activity. If you maintain separate staging and production servers, you might have to regularly update the schema and data on the staging server so that it matches the production server.
Common High-Level Tasks
In the following table, you can find descriptions of common high-level tasks that support this scenario and links to more information about how you can successfully complete those tasks.
Common Tasks |
Supporting Content |
|---|---|
Synchronize schemas between your production and staging databases: You can compare the schemas of your production and staging servers and specify which changes you want to synchronize. |
|
Synchronize data between your production and staging databases: You can compare the data on your production and staging servers and specify which changes you want to synchronize at the table level or even at the row level. |
Compare and Synchronize Data in One or More Tables with Data in a Reference Database |
Troubleshoot problems: You can identify and correct common problems that you might encounter when you compare and synchronize schemas or data. |
|
Perform routine operations tasks: Back up your database, manage your transaction log, monitor your database, and tune the performance of your database. |
On the Microsoft Web site: Backing Up and Restoring Databases in SQL Server Backing Up and Restoring How-to Topics (SQL Server Management Studio) |