How To Backup Sql 2000 Server Database Without Having Same Backup File Name?
After i did a backup database in Enterprise Manager, lets say the backup file name is “customer”.
Then i backup the same database again, and it replaced the old one (customer). How can i make the backup file name to become “16032007-Customer” (for 1st one) and “17032007-Customer”, according to date?
Hi there
I guess you have to do it manually
On windows 2000 server
go to start button then go to programs and select
microsoft sql server
select enterprise manager
collapse the microsoft sql servers
then collapse sql server group
choose your database name
select your database and right-click on it
select all tasks
choose backup database option
you will see database name
then bellow that there will be destimation
click on add button and select where to put you backup file
click the button which has the 3dots on it and input the file name that you want to save your backup file with
good luck