I think you need to figure out why you built up 56GB of transactions. Also, you need to work with your network team to figure out what is going...

Daryl-273852 (6/15/2011)

---

One possibility is to create a warehouse type of table that is the structure of your tables with an additional column for the source-table-identifier. Then you could have...

Well, first we need to deal with your misunderstanding.

Mirroring does not restore transaction log backups. Transactions are sent to the mirrored database and applied as fast as the system...

Lee,

I believe the above is related to a single...

Yes, I can think of ramifications - index fragmentation, file fragmentation - and basically, just a waste of time and resources.

If you are constantly shrinking a file - and then...

It is just a numbers table.

sqlnaive (6/13/2011)

---

I ws actually looking from same point of view. To reduce lockings. However just this factor does not justify to have different sql instance on same server or does...

4u.chethan (6/13/2011)

---

I think from SSMS database monitor

we can only find the status but i want to know till which transaction log backup its been mirrored.

is there any way i can...

sqlnaive (6/13/2011)

---

Hello Guys, Recently I was looking for one option as per our requirement. I've read about Mirroring, replication etc. I have one prod server and now need one different...

Lee Crain (6/13/2011)

---

Jeffrey,

Sorry I took so long to respond on this subject; I've been very busy.

I knew I'd read documentation to the contrary of your assertion. Adding data to...

sqlfriends (6/12/2011)

---

Thanks, that's what I experienced too. So I will use in the server then.

But for sql profiler trace, can you confirm it is easy to run on my local...

In addition to Steve's advice, you need to put together the plan for the downtime.

Step 1: Document cluster configuration

Step 2: Document service accounts used for each service

Step 3: Document AD...

I really don't know where these articles are that recommend letting SQL Server manage the memory. Anyways, here is what I have found to work on x64 hardware:

With lock...

I guess I still don't get it - you are looking at modifying when you backup the databases, and not when that is copied to tape.

I would be worried about...

Check the dependencies on the service - you are probably missing one or more that are required for SQL Server to start.