That's not completely true and exactly what this article seeks to discuss. If you introduce a failover clustered instance of sql server into the AO group there is still shared...

Good article.

IMO Microsoft has "one upped" Oracle with Always On over Oracle's RAC solution.

I am a multi-platform DBA. I administer both SQL Server with Always On, and Oracle RAC. SQL...

I know this is an old topic but I thought I'd update it anyway. I did find a way to backup standby databases using the "backup" command. It works...

tskelley (1/17/2014)

---

Many thanks, this is much cleaner than my previous code.

I did add

AND INDEX_ID = 0

to the WHERE clause to keep my name list unique and not show indexes....

If your backup solution/server version allows you to restore transaction logs created after a full backup to an earlier full backup file without having the differential backup or full backup...

I dont think thats...

Thanks for a very good article.

On myth 10 - you cannot backup a mirrored database - I think you meant to say that the myth is that you can...

Since SQL always registers an SPN when it starts, using setpn to find the instances might be faster than using "new view"

setspn -F -Q MSSQLsvc/*

I'm sure this could be massged...

I'ts really not much different than the way SQL or Oracle does it. DDL and DML is recorded in the log in the order in which it occurred. Recover it...

Thats one of the things I always liked about MySQL. The logs contained essentially just plain old SQL. If you needed to undo something that someone did you could...

Couldn't agree more. By default I think the alert threshold is 45 minutes. I set it to 3 hours, and like you, I schedule the alert job not to run...

Yes. Its very similar. The difference is that with log shipping you need to have 3 agent jobs. On the primary there's one to run log backups. On the secondary...

Mimicking the primary volumes on the secondary isn't always possible. Sometimes you have to work with what you are given. I log ship about 500 primary databases from 40 or...

I think the main risk is if an administrator's account becomes compromised.

I myself do not use xp_cmdshell. If I need to script something using the command shell I'll put it...

It did (help someone else). I just encountered the same problem.

Thanks.