Backup Names

[Utahduck]

Okay, here is a real mellon scratcher. I've got a server I've got
semi-automated backups on. A typical backup looks like:

BACKUP DATABASE Master
TO DISK = 'c:\backups\Mas ter20070418.bak '
WITH FORMAT

Then I'll do a log backup if applicable (Not for Master). I then get
some error about the device being offline. But if I run:

BACKUP DATABASE Master
TO DISK = 'c:\backups\Mas ter20070418.log '
WITH FORMAT

then it works fine. The ONLY thing I've changed is the extension on
the backup file. But that is what I wanted to name the log. As a
workaround I have the backups saved as:

Master20070418-bak.log and then name the log files the way they should
be. That works, but I don't like it.

Security is full access to Everyone, so I don't think it is an access/
permissions issue.

Any ideas?

Thanks,
-Utah

[Erland Sommarskog]

Re: Backup Names

Utahduck (Utahduck@hotma il.com) writes:

Okay, here is a real mellon scratcher. I've got a server I've got
semi-automated backups on. A typical backup looks like:
>
BACKUP DATABASE Master
TO DISK = 'c:\backups\Mas ter20070418.bak '
WITH FORMAT
>
Then I'll do a log backup if applicable (Not for Master). I then get
some error about the device being offline. But if I run:
>
BACKUP DATABASE Master
TO DISK = 'c:\backups\Mas ter20070418.log '
WITH FORMAT
>
then it works fine. The ONLY thing I've changed is the extension on
the backup file. But that is what I wanted to name the log. As a
workaround I have the backups saved as:

I'm not sure that I follow. I think what happens is that you run a
BACKUP LOG statement (which you don't show), and this yields an error
(which you don't show).

Maybe you could clarify by posting the actual command that is
causing you problem and the error message?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server 2005 at

http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

Books Online for SQL Server 2000 at

http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx