>Hi Folks,
>Thanks for all your comments and suggestions.
>
>However, I still dont know where else, other than the LDF and the MDF data is stored. I know I may not need this info bit I am curious.
>
>Also, it seems that most solutions require the user to go into SQL server management studio (or simular) to start the backup.(other than purchased Backup Solutions)
>Is there any solution where I can have an icon on the desktop, or a scheduled event , of some sort.
>
>Scheduled events were mentioned in 'Enterprise Server'.... what is that ?
>
>Regards.
>Gerard
If you want to run as a scheduled task (instead of using Management Studio where you can schedule backups) you can create a batch file that calls the SQLCMD utility and runs a BACKUP DATABASE T-SQL command. You can do this in any version of SQL2005. In SQL2000 you would use the OSQL utility instead.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________