Posted by: rawbee May 16, 2008
SQL Problems n Tips
Login in to Rate this Post:     0       ?        

Thanks Cyberdude..keep posting ur tips...\

TIPS : How to backup database with datetimestamp in file name?

USE master;

DECLARE @FileName NVARCHAR(1024)

SET @FileName = 'F:\data\AdventureWorks2008\backup\AW2008'+REPLACE(REPLACE(CONVERT(varchar(100), GETDATE(), 100),':','_'),' ','_')+'.BAK'

SET @FileName = REPLACE(@FileName,'__','_')

PRINT @FileName

BACKUP DATABASE AdventureWorks2008 TO DISK = @FileName WITH NOFORMAT, INIT, NAME = N'AdventureWorks2008-Full Database Backup'

GO

Is that helpful for you????????

Continue..............
Read Full Discussion Thread for this article