Backup Problem

[NormRumac]

Several months ago I foolishly named my SQL (actually MSDE) database "my-database". Over the last few months several applications which reference the database with this name have been created.

Now that the database has recently gone from "test" mode, to "production" mode, I want to start doing automatic scheduled backups. I created a script to be processed my the Osql.exe utility. This script consists of one line:

BACKUP DATABASE my-db to disk = 'c:\temp\db.bak'

As it turns out, osql.exe will barf on the '-' part of 'my-db'.

I can obviously get around this problem by renaming the database, but then all those existing client applications which reference this database are going to break.

So what can i do now?

 

[JayKusch]

Try ...

BACKUP DATABASE [my-db] to disk = 'c:\temp\db.bak'

Thanks

J. Kusch

 

[NormRumac]

That did the trick!

Thanks!

--Norm