how to backup sql server 2005 express database

[Kurt111780]

Hello,

I'm new to SQL Server and I want an easy way to backup the database daily.

I used SQL Server Management Studio Express and created a database.bak file.

Do I have to do this everyday I want it backed up?

Thanks,
Kurt

It's only easy when you know how.

http://www.seedandgarden.com

 

[Catadmin]

Backups should be schedulable in SQL Express. You could either create a new scheduled job with a T-SQL script to backup the database (the syntax, I believe, remains the same as the Backup syntax for SQL 2000) or you could create a new DB Maintenance Plan under Management -> Maintenance Plans.

Jobs are located under SQL Server Agent.

Hope that helps.



Catadmin - MCDBA, MCSA
"The only stupid question is the one that *wasn't* asked.

 

[Kurt111780]

All I have under Management are Sql Server logs and Activity Monitor. I've never used sql 2000. I wish they would make this easier. I don't really want to make a script.

Kurt

It's only easy when you know how.

http://www.seedandgarden.com

 

[Catadmin]

Unfortunately SQL Express is only meant to be a desktop version of SQL. It doesn't have the functionality of Standard or Enterprise edition.

Do you have access to the SQL Server Agent menu option? It's not under Management.



Catadmin - MCDBA, MCSA
"The only stupid question is the one that *wasn't* asked.

 

[Kurt111780]

I don't see it.

Is there another way? I can't just backup a folder somewhere?

It's only easy when you know how.

http://www.seedandgarden.com

 

[Catadmin]

You could back up the data file & the log file, but that's not quite the same thing as making a true backup file for SQL.

I read somewhere that the new SQL Scripter includes the ability to have Backup utilities that backup Windows actually backup SQL. Does anyone know if Express includes that capability?

Oh, if you have Visual Studio installed, you could write a SQL Management Object that backs up your database. Do you have this? If so, I can give you the code we learned in a SQL 2k5 class for creating the button. It's not scheduled, but at least, it'll only be the click of a button.



Catadmin - MCDBA, MCSA
"The only stupid question is the one that *wasn't* asked.