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 - 2004-03-22 : 08:42:10
|
| Reza writes "Hello,1-SQL-server of my company is became full every day 3 or 4MB and this happand every day.Our application is installed on D:\ and SQL on C: part of hard disk. How could be and why come 3 or 4 MB every day on c:\ part of HD?2-When we make backup with ARC2000, the backup can not make a backup of sql-data and sql directory. why?With windows backup I taked the massage that the file is in use(at 3:00 am).I hope that you understand my question an d can give me answer.Best RegardReza" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-03-22 : 23:13:22
|
| 1. We don't understand what you are saying. Can you send us a Visio diagram of your environment?2. ARC2000 cannot backup open files. You need to make a nightly backup of your databases and back that directory up. Do not backup the data and log directories. It can cause problems with SQL Server and ARC2000.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-03-22 : 23:17:38
|
| You mean there's 3-4 MB left on the disk?Is your database in full recovery mode and you're not taking log backups? If so set it too simple.If not what is filling up the disk.==========================================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 server harddisk is full