One question that would affect which way it's done is what version of SQL are you using Full suite or SQL Express.
If it's express I would suggest doing it in stages
c:\>OSQL -E -S ITSVCSMCAFEE\EPOSERVER
1>BACKUP DATABASE ePO4_ITSVCSMCAFEE TO DISK = 'c:\temp\backup060212.bck' WITH INIT, SKIP
If your using the Full SQL server then just use the Management console to backup the database
sorry. but how do i check which SQL version i have currently in my system?
I believe while installing ePO4.5, the installer auto installed SQL 2005 for me. Is that the express version?
Your method worked! Thanks! I managed to successfully backed up my database