SQL Server 2008 Express - "Best" backup solution?
- by Alexander Nyquist
Hi!
What backup solutions would you recommend when using SQL Server 2008 express? I'm pretty new to SQL Server, but as I'm coming from an MySql background i thought of setting up replication on another computer and just take x-copy backups of that server.
But unfortanetly replication is not available in the express edition.
The site is heavily accessed, so there has to be no delays och downtime. I'm also thinking of doing a backup twice a day or something.
What would you recommend? I have multiple computers I can use, but don't know if that helps me since i'm using the express version.
Thanks