msSQL server management studio

[vale]

This is a bit off topic but hey I need help (hold the jokes please).

I am running a win2k advanced server and on this server I have msSQL server 2005. Now my issue is to do with backing up the servers databases. Using the management studio that comes with the SQL server I can back up the databases manually, but doing this everyday for each database is a waste of my time frankly so i have been trying to find a way of doing this automatically.

I cant see anyway of doing it automatically in the studio and the microsoft website just talk alot of bollocks, I was thinking of setting up a batch file with the cmds for command line to back up the databases and then just stick that in the windows scheduler. But even then I have to find the commands to do so.

I know there might be a few of you in here that might have some experience in this matter. If not fair enough but any help would be good.

[putty_thing]

but doing this everyday for each database is a waste of my time frankly so i have been trying to find a way of doing this automatically.
No, spending time on MSN at work, then going home to play eve is a waste of your time.

I cant see anyway of doing it automatically in the studio and the microsoft website just talk alot of bollocks,
Are you sure? There must be something on technet/builtin for this. Can't you just backup the raw DB files?

Don't you pay Microsoft for support on these sort of things? :P

[SlyDave]

MSSQL SM supports a massive number of ways to backup databases, partial database, transactions logs, commited logs, raw datbase files, replication data (slave, master, publish, subscibe) etc etc.

All you need to do is created a task to conduct the backup (within MSSQL SM, not windows task manager). I can't give exact instructions as I haven't got it installed anymore and I use mySQL databases at work.

But what you want to do is very possible - one thing to note MSSQL only supports backing up to the local file system, even if you mount a network share as a local drive, you can't backup to it - use replication for that, or a post task cmd script to copy it.

[vale]

Oh i want to backup locally so thats not a issue.

I need to setup a maintenance plan I believe so gotta figure out where to go from there. And putty no we dont pay microsoft for support because were cheap skates and your just jealous of my msn and irc powers at work...well maybe but dont bring eve into this.

Shouldnt you be doing your final project?

[SlyDave]

Indeed, create a maintenance plan, which will automatically create the backup profiles (based on the options in the plan).

To be honest, the MSSQL manager is as simple as it gets, everything is walk through, point here, click this, are you sure you want to do this? etc etc.

You shouldn't have any problems :P failing that google is your friend there are zillions of guides on how to do this stuff.