One small doubt that is still bugging me is that when i see the size of the log, of the newly restored db, it still shows 17 GB.....if it does not have any transactions before the time it was restored then what does the 17 GB log have??
Probably 17GB of empty space. A restore recreates the DB as it was at time of backup, down to the exact file sizes. Hence if you back up a database with a 17 GB log file and restore it elsewhere, the log file will be 17GB in size.
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass