How can I get the database backup name with timpstamp

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Abhijit More SSCertifiable Points: 6897 More actions · Answer 1

Use Dynamic Query to do this.

declare @dtbak varchar(50) = replace(replace(getdate(), ' ', ''), ':', ''), @sql varchar(1000)

select @dtbak

set @sql = 'backup database db1 to disk=''d:\Backup\a_'+ @dtbak + '.bak''';

print @sql

Abhijit - http://abhijitmore.wordpress.com

forsqlserver SSCoach Points: 18902 More actions · Answer 2

Dear Abhijit Thanks,

I want the backed up database name with timestamp when backup command has run.

Thanks

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 3

forsqlserver (6/29/2011)
Dear Abhijit Thanks,
I want the backed up database name with timestamp when backup command has run.

Just try yourself with the help of sys.dataabses

I hope you'll try.

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 4

muthukkumaran Kaliyamoorthy (6/29/2011)
...I hope you'll try.

I strongly second that forsqlserver!

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 5

Search backup in our scripts section. There are lots of examples that do exactly what you are looking for.