sql2005 express on be12.5

[MyLee]

I want to backup sql2005 express, but i didn't find any menu. it is totally different with sql2005 standard or enterprise.
could somebody tell me the truth? does be12.5 support or not?
thanks in advance.

lee
 

[CraigV · Accepted solution]

Hi,

If you load up the SQL agent you will be able to backup your DBs. BE uses SQL Express for its own database.
Without it, you're going to have to do a flat-file backup by stopping SQL, and then backing up the files there-after.
Using the agent allows for online backups and restores.

Laters!

[MyLee]

oh, my god. i forgot install the agent for the server.
i am installing it now. thanks for your infomation.

10 minutes later:
it works.
thanks, craigv.

[CraigV]

Cool, can you close this 1 off then...? =)

[CraigV]

Hi MyLee,

Can you close this 1 off...?