Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

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.

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.

Compare and Synchronize Database Schemas

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.

Troubleshooting Schema Compare Issues

Troubleshooting Data Compare Issues

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)

Backing Up and Restoring How-to Topics (Transact-SQL)

Transaction Log Management

Monitoring (Database Engine)

Performance (Database Engine)

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2015 Microsoft