Ref: Books OnLine (BOL), go to index tab, type in Transaction Log. Then review the following sub-sections: backing up, shrinking, truncating.

If you aren't doing Transaction Log backups, then run the...

s_atai,

I agree with Antares that you need to look into getting a faster tape drive or finding out why yours is so slow. I was backing up 190 GB of...

As I said, I'm using an active/passive cluster. I am doing some kind of backup every hour. Once a day, I do a full backup, then every 4 hours I...

Here's my thoughts on both of your options...

1. "While the failover is not automatic, I would still be in business in a matter of approximately 15 minutes." This is true...

Rustroot1,

I believe you missed part of my post...we do have two Raid controllers, yes they are SUPPOSED to be redundant. But we lost one and the other could not accept...

My shared storage has two RAID controllers, each handles half of the drives. If one fails the other is supposed to take over. I can come up with lots of...

You say the "...Database doesnot contain any object named 'TempTable'". So why are you trying to select from a table that doesn't exist?

A stored procedure will parse and compile when...

A cluster is two or more servers with one or more shared storage devices. We have a DELL cluster. Our two servers are 8450's and we have two shared storage...

I only do the full backup for Master, Model, and MSDB. I do the transaction log backups, differential backups, and full backups for my database.

Why? Well as I understand it,...

I found more in Books OnLine....it says 'Only a full database backup can be perfomed on the master database.'

Ref: Books OnLine, Index tab, keywords BACKUP DATABASE. Select the option that...

My understanding (and experience) is that MASTER is set for SIMPLE recovery method. You can ONLY do a FULL BACKUP of MASTER. LOG backups are not an option and I...

The green arrow means the SERVICE is started (MSSQLSERVER service or SQLSERVERAGENT service).

The red line means you are connected.

You can't connect without the service being started, but you can have...

John,

I did use those scripts. I know for a fact that my differential will not work with the fullbackup. However, I couldn't recover my database because I had used NORECOVERY,...

SOrry about posting in the wrong place. The differential backup would not restore and of course the only error was that it couldn't be applied to the database. The only...

Okay, in Enterprise Manager, next to my database is says (Loading). I can not find anything that says what that indicates.

My differential and transaction log restores failed because the database...