Kevin Remde's IT Pro Weblog
IT Pro Resources
TechNet EventsMicrosoft Security Response CenterTechNet IT Manager Community HubMicrosoft 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
Keith MayerIT Pros ROCK!@KeithMayer
Kevin Remde Full of I.T.@KevinRemde
Matt Hester Matthew Hester's WebLog@MatthewHester
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.