pdanes (10/17/2012)

---

Jamie Scharbrough (10/17/2012)

---

The answer to this is: It depends.

I guess I'm approaching this with the view that this is a learning enviornment, and so you should do all...

That's what I would like to be able to do. But I'm still wondering, does this three-stage approach make that any more doable? If I take a differential backup every...

OH, I see. In that case...

Actually, let me just link you to a very easy tutorial.

http://www.petri.co.il/create-backup-job-in-sql-server.htm

Let me know if you're confused or lost; I'd be glad to help.

No, that was great! I hadn't heard of SequoaView; I was thinking of running reports and figuring out a) where the main space issue was coming from, b) where the...

What about just setting up a job and an alert so you know if something's gone wrong?

Or do you not have access to the server?

pdanes (10/17/2012)

I agree as well - recovery is the ultimate goal, but once again, I can't even attempt a recovery if I haven't made a backup, and I can't make...

I like your enthusiasm!

I was really ticked off when I heard about it, but because I'm a beginner, I usually keep my opinions to myself.

I was also hesitant to...

I agree with everyone who's said you need to be concerned about recovery, but I also understand where you're coming from.

I'd say a weekly full (I like Sunday nights,...

Butting in for just a second, it sounds like you don't have enough space to shrink the whole file at once. I would check DBCC SQLPERF and see what you...

Hey!

As far as I know, after looking at Microsoft's Express Edition for 2008, Express CANNOT support SQL Server Agent. Your best bet is to download the 180 day trial for...