Thursday, February 16, 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...
> > 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?
>
>|||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...
> 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...
>> > 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?
>>|||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...
> > 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...
> >> > 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?
> >>
> >>
> >>
>
>

No comments:

Post a Comment