Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-05-05 : 07:50:54
|
| kuldeep writes "Dear SirI am having two prob in sql server plz help me. 1- How can i restore database with the help of log files.2-I have a very big database around 20 GB so how can i restore that database while this is not possible directly.thank youkuldeep singh" |
|
|
franco
Constraint Violating Yak Guru
255 Posts |
Posted - 2003-05-05 : 08:47:03
|
| In order to restore a database you need a full database backup as a starting point.You will have differential backups and transaction log backups if you have plan to have it in your backup strategy.In order to perform a point in time restore the sequence will be:Restore last full db backup with norecovery option.Restore diff backup with norecovery option.Restore all your t-logs backup with norecovery options except the last one.Please refer to BOL on "restore database".I don't clearly understand what you mean by your second question.HTHFranco |
 |
|
|
|
|
|
Question