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.

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.

To Bali, again

Again, I come to Bali. A place where I can feel fresh air which is difficult to find in Jakarta. There are also many places of interest : beach, hill, rice field etc.
Exploring Bali with motorcyle is very nice, I can feel wind blows, and the sun shine burn my skin.

I hope I will come back to Bali, soon :-)

First appearance

This is the first time I create blog. I have been working as IT programmer for a couple of years, frequently visit other's blog but just this day I interest in creating my own blog.

My first impression of this site is that this looks very simple and easy to use. I wish this can be a way to share knowledge and experience with them who have similar interest with me.