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 |
|
ORS
Starting Member
3 Posts |
 Posted - 2011-12-18 : 05:52:05
|
| I have an operational DB , and when creating a backup , .bak file size is 8GB . later , I restore the backup to a different DB , and then backup the new one. Now, .bak file is 1.5GB I am backing up just the DB , without its TLog DB. A --> backup --> A.bak(8GB) --> Restore --> B --> backup --> B.bak (1.5GB) Do u know the reason for it ? Does it hide any performance issue ? will I gain something from restoring the backup on the original one ? Appreciate your help |
|
|
pnash
Starting Member
26 Posts |
Posted - 2011-12-18 : 07:04:26
|
| are you taking SQl native backup or any third party software.? are you taking only filegroup or file backup without log backup? |
 |
|
|
ORS
Starting Member
3 Posts |
Posted - 2011-12-18 : 07:25:13
|
| i use SQL server command: BACKUP DATABASE [DB_NAME] TO DISK=[FILE_PATH] WITH NOFORMAT, INIT |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2011-12-18 : 23:34:12
|
| Maybe your 8GB backup included a huge number of transactions? |
|
|
|
|
|
|
Backup DB Size