There are a number of reasons to rather do an OFF LINE rather than a DETACH when moving database files like this. In SQL 2005 there was a particular issue...

Using MDF, NDF & LDF is really historical and convention more than anything else, it does however allow the files to be easily identified as database files. When you move...

This PDF from Microsoft is quie easy to understand "SQL 2012 Licensing Datasheet" and can be found with a search on Google, but try get the latest version.

The 2 x...

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,...