Wednesday, December 6, 2006

SQL Server : Backup to different machine

There was a question that I curious how to backup sql server database to different machine (using Universal Naming Convention path).
Now I find the explanation in the books online and a clue from some internet resources :-)
It is the login account that is used to start the sql server instance that matters.
When I choose Local System account, it doesn't require password, but it does not have network access.
To have network access, I use domain user account and restart the service. It now can access \\servername\folder that is accessible by the domain user account.

Tuesday, December 5, 2006

SQL Server : Scheduled backup

SQL server 2000 has facility to schedule jobs. One of them is scheduled backup.
This can be done through database maintenance planner wizard.
We can specify how recurrent the backup will take place and how long the old backup file reside until it is overwritten.
However, I do not find a place where I can specify how the file name format would be.