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 |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
 Posted - 2007-12-12 : 14:26:49
|
| what will be size of backup file(FULL) for 1TB database. Just wanna make sure backup is done right.I did a full backup of 1TB database and backup file came like 507GB. I am using GUI for backup.But it completed 100% but didn't give me the screen'The backup is completed successfully' .it says executing---0% |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-12 : 14:36:46
|
| It'll be about the same size as the filled portion of the MDF file.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2007-12-12 : 14:38:23
|
| So Tara why didn't i get 'The backup completed successfully' in GUI.Do you think 507GB is good for 1TB database size. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-12 : 14:40:56
|
| Try using BACKUP DATABASE command instead just in case.BACKUP DATABASE YourDbNameTO DISK = 'F:\Backup\YourDbName.BAK'WITH INITI have no idea if 507GB is the right size of the backup file. If it is, then your database is smaller than you think. You are probably saying 1TB due to the size of the MDF file.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2007-12-12 : 14:45:51
|
| The database is on Simple recovery mode and From properties of database, i can see the size of 1TB. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-12 : 23:40:50
|
| How much space used? Backup file size is similar to used space size. |
|
|
|
|
|
|
SIZE OF Backup file