Kevin Remde's IT Pro Weblog
IT Pro Resources
TechNet EventsMicrosoft Security Response CenterMicrosoft Virtual AcademyKevin’s Evaluation Download Center
IT Pro Evangelist Blogs
Blain Barton Blain Barton's Blog@BlainBar
Brian LewisMy Thoughts on IT...@BrianLewis_
Dan Stolts IT Pro Guru Blog@ITProGuru
Jennelle Crothers TechBunny@jkc137
Kevin RemdeFull of I.T.@KevinRemde
Tommy PattersonVirtually Cloud 9@Tommy_Patterson
Yung Chou Yung Chou on Hybrid Cloud@YungChou
SQL Server 2005 Tidbit 007
Number 7 comin’ atcha!
This tidbit comes as a result of a question an attendee from one one of our live TechNet Events emailed me.
"Can backups, etc, generated from a maintenance plan in Yukon have the same file name instead of a unique name?”
I can't find any information on this specifically, although I know that one of the plan steps you can create is just a T-SQL step, where it launches whatever script you want to launch. That could be a BACKUP DATABASE MyDatabaseName TO DISK = '\\MyServerName\Backups\MyDatabaseName.bak' (or a disk location, or some other defined device)With options to append or overwrite, etc.
Got an IT question? Give me a comment, or contact me.