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 |
|
Paul555
Starting Member
1 Post |
 Posted - 2008-11-28 : 04:55:52
|
| Hi,I have a problem with SQL back up using Veritas.When the back up starts the free space on drive C: drops dramatically from about 13GB to about 600 Mb.It gets less every time it backs up eventually it will run out of space. when the back up is about a third of the way through the free space jumps back up to about 13 GB again.I think it is a snap shot of the databases that is causing it but I may be wrong.Can anyone tell me how to stop this from happening and why it does it?Thanks.Paul. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2008-11-28 : 18:45:39
|
| What do you have on the c drive?Do you have any of the database files there? I would hope not but maybe you have tempdb?I doubt if it's a database file issue as that wuldn't give back the space.More likely is a work file that veritas is using.Can you configure it to put work files somewhere else?Should be easy to see what is taking the space while t's happening.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
SQL and Veritas