November 19, 2009 at 3:41 am
While taking the backup whether pages will be allocated or not
Thanks
Parthi
November 19, 2009 at 4:19 am
Sorry, don't understand the question.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
November 27, 2009 at 3:10 pm
I think your question is pointed to "if pages are allocated or data can be inserted when the backup is running.", if this is true, the answer is YES.
November 29, 2009 at 11:34 pm
Hi
I little bit confused with that one.My thing is whether Pages are there in Transaction Log
(.LDF).Pages are will be there are not.After that i get to know that
"Log files do not contain pages; they contain a series of log records"
One more Thing how does the MDF,LDF file size reduce in Normal Backup
Thanks
Parthi
November 29, 2009 at 11:48 pm
parthi-1705 (11/29/2009)
I little bit confused with that one.My thing is whether Pages are there in Transaction Log
No pages in the transaction log. The data file is divided into data pages
One more Thing how does the MDF,LDF file size reduce in Normal Backup
They don't. A backup will no reduce the size of anything
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply