Tuesday, February 14, 2012

backup

My backups have been successful until last week. I am suddenly getting the
message telling me there is not enough space on the disk. The disk has 215gb
of free space. I am backing up to an external firewire hardrive. I can
successfully do a backup to the same disk as the database.
I do a differential backup on certain days and a full back up on others. I
append the transaction logs to the backup.
The database is only 18gb.
Any ideas why this is happening?log file size ?
scott
"Curtis" <Curtis@.discussions.microsoft.com> wrote in message
news:D8773822-D6B8-44A6-A2A7-DA981D5081D3@.microsoft.com...
> My backups have been successful until last week. I am suddenly getting the
> message telling me there is not enough space on the disk. The disk has
> 215gb
> of free space. I am backing up to an external firewire hardrive. I can
> successfully do a backup to the same disk as the database.
> I do a differential backup on certain days and a full back up on others. I
> append the transaction logs to the backup.
> The database is only 18gb.
> Any ideas why this is happening?|||The log file is 13.2 gb. The log says the transaction log portion of the
backup was successful. It seems to fail on the full and differential.
"scott" wrote:

> log file size ?
> scott
> "Curtis" <Curtis@.discussions.microsoft.com> wrote in message
> news:D8773822-D6B8-44A6-A2A7-DA981D5081D3@.microsoft.com...
>
>|||How do you perform BACKUP operation? In two /three steps?
What does the ERROR.LOG say?
"Curtis" <Curtis@.discussions.microsoft.com> wrote in message
news:AE908938-E143-46E1-AA98-9860EBDD4E3F@.microsoft.com...[vbcol=seagreen]
> The log file is 13.2 gb. The log says the transaction log portion of the
> backup was successful. It seems to fail on the full and differential.
> "scott" wrote:
>|||I have a maintenance plan set up. Full/Differential are executed first and
then I append the transaction log to the backup.
Executing the query "BACKUP LOG [Database] TO [ WK 4 SU Full] WITH
NOFORMAT, NOINIT, NAME = N'backup_20060827211052', SKIP, REWIND, NOUNLOAD,
STATS = 10
" failed with the following error: "Write on "WK 4 SU Full(I:\\Week 4\\WK 4
SU Full)" failed: 112(There is not enough space on the disk.)
BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems
with the query, "ResultSet" property not set correctly, parameters not set
correctly, or connection not established correctly.
"Uri Dimant" wrote:

> How do you perform BACKUP operation? In two /three steps?
> What does the ERROR.LOG say?
>
> "Curtis" <Curtis@.discussions.microsoft.com> wrote in message
> news:AE908938-E143-46E1-AA98-9860EBDD4E3F@.microsoft.com...
>
>

No comments:

Post a Comment