April 4, 2008 at 11:33 am
I used to use this at previous clients but never saved the syntax becuase hoped I would never need to do this nor be back on sql 2000.
I need to backup all databases, obvously excluding master, pubs, model and tempdb to a file on my H:\ drive using T-SQL. However, I need to append the servername and date with time to the backup file so we can tell the diff between the files on several servers. I will then just place this in a job as opposed to running a maint plan and need to do this because of new naming conventions. Can someone please help? Thanks.
April 4, 2008 at 12:18 pm
Flip through the backup scripts in the site here. There are lots to do what you want, or close to it.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply