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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-01 : 23:21:19
|
| Sandip writes "Sir,When i am restoring..my database from Backup Device...it is asking for too much space. and my Database Size is around 1.5 Gb only.. and it is being resotered in 20 gb...even then asking for 26 gb Space Pls adviceThnx in AdvanceSundeip " |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-01-02 : 09:27:22
|
| How does it "ask" for space (in my experience, restoring the database isn't an interactive process...)?Anyhow, I am guessing that when you say your DB size is 1.5 GB you are referring to the size of the data file. The rest of the space is probably taken up by the log file (especially if you haven't done log backups in a while). |
 |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-01-02 : 09:49:00
|
| why not do an sp_detach_db with it and you can ignore the log file entirely. Search the site for sp_attach_db for syntax and more info. |
|
|
|
|
|
|
Restore