• sreekanth bandarla (3/7/2014)


    BTW, here is the KB article on how you can do that...

    http://support.microsoft.com/kb/2019698

    sreekanth, I went to the link you provided. I've gotten the SQL script that's on the page, put it into its own .sql file and ran it in my SQL Express, putting the new SP into the master database. Then I created a .bat file, appropriate for my situation, and scheduled it into my Task Scheduler. I let it run at noon, my time. I then checked the status of the run; it ran fine. However, when I went to look to see if the .bak file was where I specified it should be, it wasn't. Is it because my recovery model is specified as Simple?

    Kindest Regards, Rod Connect with me on LinkedIn.