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 |
|
under2811
Constraint Violating Yak Guru
366 Posts |
 Posted - 2008-10-16 : 02:10:56
|
| Hi All,I am experiencing un-even behevior of Server back ups..I have two databases in which one having transaction like creating tables and inserting records into tables and again inserting these records into master tables and finally these created tables gets truncated while in second DB i am changing only those records which are modified and creating some tables but not like in first DB .. records in both DBs are may or may not be same only few i.e total may vary in range of 50 to 60 records..when i took back up then size of both DB vary first one is 550632 KB and second is 435123 KB.. i checked mdf and ldf files also they are same...please let me know where is difference???T.I.A |
|
|
SimpleSQL
Yak Posting Veteran
85 Posts |
Posted - 2008-10-16 : 03:53:07
|
| Is there any particular reason why you are concerned abt size difference, it does not seem too big? |
 |
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2008-10-16 : 05:25:34
|
| but my concern is why it happens?? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-16 : 08:51:52
|
| Backup only takes the used portion of databases so they won't be same. |
|
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2008-10-16 : 09:33:48
|
| Backup type is "FUll" for both DBs |
|
|
|
|
|
|
back up size vary for same records of DBs