My app in VB 2005 Express needs to backup the SQL database daily. Since I understand VB a lot more than I do SQL, I initially went about just copying the .mdf and .ldf files. Even though the connection is closed, I still get a "file in use" error.

So I guess I have to do it the proper way and use the "BACKUP DATABASE" command, however what is the name of my database? I've tried using "CallLog" and "CallLog.MDF" which are the filenames. I do not see any way of finding or changing the name of the database I created in SQL Express 2005.

And assuming I can get the name of the database, will it still backup correctly even though it's constantly "in use" as stated above?

Greg