I'm using Win2k Server w/SQLServer2K. I recieve a database dump every night and I use the restore function to put it in my SQL Server then I have to rename the Database to a date format ("03_05_03" for example). I want to know if there is anyway to automate this process. I would have to be able to rename a table with a variable (like the date).
I need to do the following things automated...
1. Grab the Database dump like "MyData.bak"
2. Restore Database.
3. Rename that Database with the day's date.
I am a newbie to this and really can't find much on this.
Hope to hear from you soon...
Thank You for your time and patience,