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 |
|
petek
Posting Yak Master
192 Posts |
 Posted - 2008-12-02 : 10:16:02
|
| Hi All,Firstly thank you for looking at this post, i am having problems backing up a database and the error returned is as:[Microsoft SQL-DMO (ODBC SQLState: 42000)] ERROR 3202: [Microsoft][ODBS SQL Server Driver][SQL Server]Write on 'D:\MSSQL\BACKUPS\HFM\HFM_db_200812021423.BAK' failed, status = 112. See the SQL Server error log for more details, [Microsoft] [ODBC SQL Server Driver][SQL Server] BACKUP DATABASE is terminating abnormally.The database had a full backup a whle ago but it's failed ever since. Any ideas.....Kind Regards PetekKind RegardsPete. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-02 : 10:30:28
|
| Anything in Errorlog? |
 |
|
|
petek
Posting Yak Master
192 Posts |
Posted - 2008-12-02 : 10:40:33
|
| thanks for replying sodeep, do you mean the windows error log?Kind RegardsPete. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-02 : 10:41:26
|
| Yes. SQL Error log as well. |
|
|
|
petek
Posting Yak Master
192 Posts |
Posted - 2008-12-02 : 10:43:19
|
| Hi Sodeep,thanks for your help it was a disk space problem.kind regardspetekKind RegardsPete. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-02 : 10:50:34
|
Ok cool .It's always good to have good tools or script to monitor disk space usage so you know what is exact issue. |
|
|
|
petek
Posting Yak Master
192 Posts |
Posted - 2008-12-03 : 08:19:03
|
| sodeep,i am being cheeky but does somebody have a script to monitor disk usage it would be great.kind regardspetekKind RegardsPete. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-03 : 10:03:16
|
| We use third-party tools for it. Did you search for it? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Database Backups......