Reply to Re: Backup Names

Your name:

Reply:


Posted by Erland Sommarskog on 04/18/07 22:01

Utahduck (Utahduck@hotmail.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\Master20070418.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\Master20070418.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@sommarskog.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

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация