is this the only database mirrored on the server. It could have been caused by a lot of things, network glitch, slow network, mirrored server rebooted.

the important thing is did...

what do you mean by timed out? Databases don't time out, calls to the database do. What was the actual message in the errorlog?

Someone else tasked with performing the DR database work. That means they may not necessarily have written the procedures and\or scripts, but knows where to get hold of them and...

first be sure they are not being used, so remove in a non-prod environment first and test thoroughly.

Avoid removing non-clustered indexes defined as unique. They may not show up as...

The old principal will take up its role as the new mirror. Users may not be aware they are connecting to a mirror, and ideally should not care. There may...

you don't HAVE to, if its not causing you amy performance issues, but you may want to to separate out the instances more.

yes you can, from the failover with command

ALTER DATABASE database_name

SET PARTNER = FORCE_SERVICE_ALLOW_DATA_LOSS

mirroring is not like logshipping, it does not have its own log backups and copy over logs, it replicates at the transaction level. Therefore you MUST continue with your log...

SQLRNNR (3/13/2014)

---

Based on the wording of the question, I have to throw this out there too!

xp_cmdshell 'net localgroup administrators'

GO

xp_cmdshell 'WMIC USERACCOUNT LIST BRIEF'

GO

xp_cmdshell 'WMIC USERACCOUNT LIST FULL'

GO

Which extended stored procedure...

yes, but the question says insert, rather than import, so does SSIS run the insert as a bulk import by default, or is that a setting you can choose..................just trying...

and 3 points worth - nice. 🙂

Stewart "Arturius" Campbell (3/5/2014)

---

Alternatively, change the recovery model to bulk logged just before the load and back on completion thereof.

however, this will require a full backup before and after.

Bulk logged...

TerrenceTheCat (3/3/2014)

---

Thanks everyone for your help today, your guidance and input is very much appreciated as always. The Database was created from a full file backup copied from another database...

GilaMonster (3/3/2014)

---

ChrisM@Work (3/3/2014)

---

GilaMonster (3/3/2014)

---

I'm going to picking your brain in the next month or so about vacation spots, I'm planning to take a off week after Bits, Wales looks close....

TerrenceTheCat (3/3/2014)

---

Hi Gail,

The reason returning to a back up does not appear to be an option is that, the person I am helping cannot determine the correct backup file for...