We have a new process to run updates on it that takes forever, so it needs a primary key or at least a unique index. One column already has a...

On the newly created database files, which are currently online:

Owner is SQL domain service account.

MSSQLSERVER

OWNER RIGHTS

Local Administrator Group

All have FULL control.

On the old files (in the same folders):

Same as above...

And are you using Domain accounts or one of the local accounts for the service?

Domain service account

Did you check the files specifically or just the...

Check, Check, Check and no joy.

The unusual thing in this circumstance is that the network drives were previously attach to an OS that no longer exists. I'm wondering if there...

More information: When run under the context of the Agent Account user, the logs show an EXCEPTION_ACCESS_VIOLATION and generates a dump file. Here is an excerpt from the...

Just for ***** & giggles I ran BACKUP DATABASE [dbname] TO DISK = 'Nul' on a test instance in VM hosted on my home computer. It took...

Is that for routine OLTP operations or just during DBCC CheckDB or repairs?

Excuse me? Are you saying that if a database is mirrored and disk-level corruption occurs the SQL will just pull the data from the mirror??

On the other hand, I recently read an article about a person having all kinds of problems in life because his last name is longer than the 36 characters a...

Normally, in SMMS the database icon is gray, and is labeled (Standby \ Read Only). This time the Icon was yellow and labeled simply (Standby).

The log shipping job which...

Fixed it. The issue was that I used an AD Group with a slightly different name from the one the users are in. Lesson: try not to take...

Yes, this is old, but here's an answer for anyone finding this thread who is in the situation I was in...

I got this error stating it could not upgrade from...

Another advantage of separate drives is that you can dedicate the fastest, most expensive solid state storage to data & log files and your backups can go on slower but...

I have joked before that I can offer perfect security by removing the hard drives and putting them in a vault.

Security is always a balance between making access extremely difficult...

While I usually use SSMS from my workstation there are a few occasions where I'm happy it was on a server:

1) During an evening power outage at the office my...