Re: mssql database backup & restore
Hi Maryam,
When a database is dumped a set of mysql statements are dumped to a text file.
When you restore this file, each statement has to go through the following process :
1. syntax of sql is checked
2. referential integrity, foreign keys, etc have to verified
3. indexes have to be created and updated
4. each sql statement has to be committed.
Hence a restore is always slower than a backup.
Cheers,
Claude Veigas
Subject
Written By
Posted
Re: mssql database backup & restore
September 03, 2010 09:41AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.