jason.spangler (8/31/2012)

---

Why rule it out because it's a production server? I would rule out running the Profiler GUI on the production server, but I wouldn't rule out running a server...

It does look like it might be intellisense crashing the restore. Have you tried it with intellisense turned off? This is mighty strange.

Do you have the deadlock graph? I suspect you might be seeing a deadlock within a system table, but I can't be sure about that, just a guess.

First, I'd stick to using 1222. It has better information than 1204. Second, yes, these are very lightweight processes. They don't put excessive load on the system. They capture the...

I'm going by what the error message says : This SQL Server edition and/or Windows Server System does not meet one or more of the requirements.

This means you've got something...

READ ONLY on a database means it no longer bothers maintaining locks because there is not possibility of data modification.

The one thing I see missing are log backups. You don't list those as the types of backups, but you have databases in FULL recovery. If you're not running log...

If the Availability Group says you don't have the right configuration, then probably you don't have the right configuration. Do you have an outstanding reboot which will finish the install...

The vast majority is done through the provided interfaces and T-SQL. But if you're really interesting in automating administration of the servers and instances, PowerShell is your bestest friend in...

Assuming the WHERE clauses of the delete statements place the processing squarely within the partition, no, I wouldn't expect to see a table lock. But, you never know. If your...

It really depends on what you're trying to do. The basic table valued function's nickname is parameterized view. These functions work pretty well on their own. They can be somewhat...

I have not used the BI edition. Standard or Enterprise is all I've done. Yes, I've done SSIS & SSRS. They're the same, effectively, in terms of licensing, as the...

I'm not 100% certain, but it could be that your backup file is corrupt. Try removing the file before you rerun the backup. Even though you're running INIT, it doesn't...

I've done a number of upgrades to 2012. There's no special things you need to do going from Standard to Standard in 2012. The upgrade process is pretty similar to...

The Availability Group functionality is not set up to move instances around. It's focused exclusively on a database or a group of databases. Now, you can make all the databases...