
I currently make multiple backups of my database using a sql script (osql -U sa -P password -S Server\sqlexpress -Q "BACKUP DATABASE name TO DISK = 'i:\Storeop.BCK'") Is there a way to have the filename outputted with the date and time intergrated in it? I do not know sql so any help would be great. Thanks
*This post is locked for comments
I have the same question (0)Hello Anthony,
www.mssqltips.com/.../simple-script-to-backup-all-sql-server-databases
to learn more about T-SQL
msdn.microsoft.com/.../aa833212(v=vs.90).aspx
good luck..