ok, means ADV.BAK and ADV2.BAK of AdventureWorks db contain the full backup. And if any on bak file get corrupted I wont be able to restore the full backup. and...

Thanks for replies guys.

Thanks all for answering my queries.

Ok, then how log file gets truncated in Bulk and Full recovery mode ? After every log backup or any other situation when truncate occurs.

Thanks in advance.

And Checkpoint flush dirty buffer to disk and mark VLFs to reusable for further use. Please correct me if I am wrong.

Thanks in advance.

Thanks for reply Gail, how does it make service pack easier to create ? And what happens if there is some corruption in resourcedb?

Thanks in advance.

Thanks all for answers.

Thanks for reply Ninja..

Thank you so much for replies.

Hi Gail,

Thanks for reply, is there any other information related to SQL logged in events log but does not log in error log file ?

Thanks in advance.

I am using the same database name on both environment.

I am restoring from production to development. On development, database is already created and users are working on it. But the moment when i restore database backup of production to...

ok fine, but what about those database users who were already there on target database and now database is overwritten.

Like : Server 1 -- database1--users1,2,3,4 took the backup of database1

target...

Thank you Gail for removing my confusion.

sure.