Q
Problem solve Get help with specific problems with your technologies, process and projects.

Taking a snapshot of the database and relevant partitions

I like to ask about backup and recovery of SQL Server 2000 servers, along with other hard disk partitions within the same server where the data is located (not an offline backup). The database only keeps a reference to this data. Most MS SQL Server reference books talk purely on backup/recovery with the database, perhaps using EM or some other tools. What can I do, in order to take a "snapshot" of the database and the relevant partitions? Is it really a snapshot or will there be some discrepancies?

If you require the synchronized backup of SQL Server databases with external resources, the only way to accomplish that is to lock out all access to the database and the external resources from all users. You would then take backups of both the database and the external resource. Since all access is locked out, they would be synchronized.

 

For More Information

This was last published in April 2003

Dig Deeper on Microsoft SQL Server Installation

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close