SQL 2005 Express Backup

Burnsy2023

Burnsy2023

Burnsy2023

Man of Honour
Joined
17 Nov 2003
Posts
36,747
Location
Southampton, UK
What I want to do is backup an SQL 2005 Express DB to the harddrive.

However, I need it to be an unattended and be done on daily basis with a unique name (possibly a datestamp?)

How do I do this? MS have changed everything from SQL 2000 which i'm used to.

Burnsy
 
have tried going into SQL Management Studio, expanding databases, right click the database you want to back up, goto tasks and then select backup?

pretty sure you can backup the db to a single bak file.
 
ruffneck said:
have tried going into SQL Management Studio, expanding databases, right click the database you want to back up, goto tasks and then select backup?

pretty sure you can backup the db to a single bak file.
Click to expand...

Thanks, that exaclty what I want to do except I want it to run it automatically everyday. Any ideas on automation?

Burnsy
 
burnsy2023 said:
Thanks, that exaclty what I want to do except I want it to run it automatically everyday. Any ideas on automation?

Burnsy
Click to expand...

unfortuantly not, as said before if you want automation you need somthing like Backupexec, but that won't back your database up as single files :(
 
ruffneck said:
unfortuantly not, as said before if you want automation you need somthing like Backupexec, but that won't back your database up as single files :(
Click to expand...

The thing is, I know is SQL 2000 you could schedule a file backup at a certain time, surely you could still do that in 2005?

Burnsy
 
You must log in or register to reply here.
Back
Top Bottom