Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Backup Database With Date Timestap In Filename

DZone's Guide to

Backup Database With Date Timestap In Filename

by
Snippets Manager
·
Jan. 29, 07 ·
Free Resource

Comment (0)

Save
Tweet
{{ articles[0].views | formatCount}} Views 
// SQL Server 2005 

DECLARE @filename nvarchar(128)
SET @filename=N'C:\Backup\master' + '_' +convert(varchar(8), getdate(), 112) + '_' + replace(convert(varchar(8), getdate(), 108), ':', '') + '.bak'
BACKUP DATABASE [master] TO DISK = @filename WITH NOINIT , NOUNLOAD , NAME = N'master backup', SKIP , STATS = 10, DESCRIPTION = N'master System Backup', NOFORMAT

Like This Article? Read More From DZone

Using the New Python Instance Properties
Using Dropdowns in Grids
Why IoT Is a Big Business Playground (for Now)

Free DZone Refcard

Data Warehousing
DOWNLOAD
Topics:

Comment (0)

Save
Tweet
{{ articles[0].views | formatCount}} Views

Opinions expressed by DZone contributors are their own.

THE DZONE NEWSLETTER

Dev Resources & Solutions Straight to Your Inbox

Thanks for subscribing!

Awesome! Check your inbox to verify your email so you can start receiving the latest in tech news and resources.

X

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.linkDescription }}

{{ parent.urlSource.name }}
by {{ parent.authors[0].realName || parent.author}}
· {{ parent.articleDate | date:'MMM. dd, yyyy' }} {{ parent.linkDate | date:'MMM. dd, yyyy' }}
· {{ parent.portal.name }} Zone