How do I backup my databases?

When I try and back them up it says I can't in the Express version, which version do I need?

Re: How do I backup my databases?

Use sqlcmd to backup your database then.

Re: How do I backup my databases?

Quote:

Originally Posted by james121056

When I try and back them up it says I can't in the Express version, which version do I need?

I don't know what your problem is, backup the database is kind of easy even with the express version (i use it and it works flawlessly).

1.
How to: Back Up a Database (SQL Server Management Studio)

or try
2.
How to backup databases in SQL Server | lynda.com tutorial - YouTube

Not even 5 minutes to google with the keywords: "sql server 2008 express database backup". :ehh:

Edit:
Look a bit around youtube and you can find tutorials for using plan (if you got the full 2008 sql version) or use windows tasks to automatically backup your databases (you can even use .batch files). Hope that helps you out with enough options :thumbup: