Perry Whittle (1/28/2013)

---

I wasnt being sarcastic i'm genuinely surprised!

you're right, i dont think theres a good reason, AO replaces log shipping and mirroring and pretty much makes them redundant 😉

Hmm,...

Perry Whittle (1/24/2013)

---

If you have availability groups set up and working why on earth do you want to use Log Shipping?

This details how to migrate from Log Shipping to AO...

Perry Whittle (1/24/2013)

---

If you have availability groups set up and working why on earth do you want to use Log Shipping?

This details how to migrate from Log Shipping to AO...

What version of Profiler are you using? I get a popup asking me if I want to open the next Rollover file.

I'm using Profiler from SQL 2008 R2.

Leo

What error do you get when adding the AG as a linked server?

The AG is a virtual SQL Server and should be created in the domain. Is it correctly created...

emile.milne (1/23/2013)

---

Thanks, thats not ideal. I think most people will use the replica for SSRS. Big flaw in the design then.

If I want to tweak the index for reports they...

Is the job actually running and working? Is the job owner sa? If not is the default database for the job owner the one containing the stored proc?

The only way...

You need to think of Always On in terms of Log Shipping or Mirroring. The secondary databases can be configured to read from, but you can't update them directly, so...

I'd get a trial version of SQL, even SQL 2005 or 2008. Install this on a VM somewhere and import everything to the trial version. Then backup and restore to...

sql-lover (12/18/2012)

---

I am not following you. The...

Looks to me like the disks aren't formatted at 64Kb. I'd definitly check this as there are some gains to be made here.

Leo

It almost looks like it's taking a long time to create TempDB which leads me to ask: How large is TempDB? Also what's the performance like on the TempDB drives,...

Perry Whittle (12/5/2012)

---

Stopping sql server is a bit like using a sledge hammer to crack a nut. You only need to take the database offline as follows

ALTER DATABASE mydb SET...

I strongly recommend you take the database OFFLINE rather than detaching. Detaching as mentioned removes the database from the system catalog, which means some database options (saved in the system...

If this is the log shipping destintion it's being recovered, and so you can't move it like this. To do the ALTER the database must be in a recovered state.

Two...