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 |
|
MuadDBA
628 Posts |
 Posted - 2009-05-27 : 22:34:11
|
| I resotred a DB from a SQL 2000 server to a SQL 2005 server, and somehow it it much much larger...it was 1.3GB on SQL 2000, but it's 11GB on SQL 2005. This is just from a restore, nothing else.What caused this? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-05-28 : 23:28:30
|
| Remember Backup files only contains the used portion of databases so it always smaller than database size. |
 |
|
|
chriztoph
Posting Yak Master
184 Posts |
Posted - 2009-06-02 : 21:55:07
|
| hi!Just a simple question..If my backup database restored successfully,is this mean that my backup is no error if i will use it again?if not how to check the backup if it is completely working or not? |
|
|
|
|
|
|
Restored DB from SQL 2K to SQL 2005 is much larger