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 |
|
tapaswani86
Starting Member
26 Posts |
 Posted - 2010-12-31 : 04:14:34
|
| Hi All,Suppose my database is in bulkrecovery mode and i am doing some bulk operations, my server crash then how i will get the data.CordiallyTapaswani |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-31 : 05:43:10
|
| Database will still be consistent after recovery. Operations that were in progress will be rolled back but anything that was committed and checkpointed should be ok.It just means that only the extent allocation is logged but the database will still recover ok.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-12-31 : 06:01:03
|
quote:
Originally posted by tapaswani86
Hi All,Suppose my database is in bulkrecovery mode and i am doing some bulk operations, my server crash then how i will get the data.CordiallyTapaswani
If you have a good backup strategy you can recover all the data till the point of restore.But to be on a safer side take a full backup with COPY_ONLY option before the bulk operations so that the log sequence does not break .PBUH |
|
|
|
|
|
|
Bulk operation