yes it is, there could be an issue somewhere in the i/o stack, get your storage people to check it out.

do you mean its timing out?

DJH-445911 (5/12/2014)

---

Thank you for the replies.

OK so let it run unless there is a reason to re-initialise. Thank you.

And I can take a full backup at any time and...

just let it run, No need to reinitialise unless you get an error (lose a log backup or something)

Your full backups do not need to be copy_only either, that only...

http://www.sqlservercentral.com/scripts/Permissions/76450/

read the comments as well for final version

Eirikur Eiriksson (5/7/2014)

---

george sibbald (5/7/2014)

---

from glenn...

without the msdb you cannot retrieve that information.

If you still have the old msdb as a backup or OS files you could restore or attach it as a user database...

from glenn Berrys diagnostic queries

-- When...

Koen Verbeeck (5/6/2014)

---

It might take a while.

The SQL Server team has the tendency lately to release more and more cumulative updates, and less service packs.

For SQL Server 2012, there's still...

try these two, searches plan cache for your index name

WITH XMLNAMESPACES (DEFAULT 'http://schemas.microsoft.com/sqlserver/2004/07/showplan')

SELECT

DB_NAME(E.dbid) AS [DBName],

object_name(E.objectid, dbid) AS [ObjectName],

P.cacheobjtype AS [CacheObjType],

P.objtype AS [ObjType],

E.query_plan.query('count(//RelOp[@LogicalOp = ''Index Scan'' or @LogicalOp = ''Clustered Index...

its not really a disadvantage as you are allowing your secondary to be gainfully used, but you will not be able to restore transaction logs to the secondary whilst users...

paul.knibbs (5/2/2014)

---

Is it? I can't recall a situation where I've actually used this facility, although I knew the correct answer...would be...

save to a new file. Makes restore process easier.

Backups are i/o intensive, so backup to a different drive. CPU will also increase if compression is used. Use of the database...

Gail,

cheers

george

Gail, is this for performance reasons or safety reasons (CI is changed or dropped), what about the redundancy and space considerations of the CI column(s) appearing twice?