SQL Server 2008 Express - "Best" backup solution?
- by alexn
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 Xcopy backups of that server.
But unfortunately replication is not available in the Express Edition.
The site is heavily accessed, so there has to be no delays and 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 I don't know if that helps me since I'm using the Express version.