how do I automate backup to a .BBK file extension?

[kskinne]

We have a fixed asset management program that has a utility for backing up the SQL database to a file with a .BBK extension.

I am familiar with automating the backup of some of our other databases to a .BCK file, using an OSQL command in a batch file, and having the batch run as a scheduled task.

Is it possible to also automate this backup in a similar fashion, only having this get backed up to a .BBK file?

Thank you for the help,

Kevin

 

[kskinne]

anyone familiar with this?

Thanks,
Kevin

 

[ousoonerjoe]

Are you sure it's not just a naming thing rather than some special format?

"If I were to wake up with my head sewn to the carpet, I wouldn't be more surprised than I am right now.

 

[kskinne]

I guess I am not sure if it is a special format, or if just changing the extension would work, I have not tried that yet - I was just hoping there is someone out there that's more familiar with this than I am , that would have a quick answer

Thanks,
Kevin