Some operation made your log grow until you filled the disk.

Unless you were running a trace at that time there is no way to know what made it grow.

The log...

It's unfortunately not that easy 🙂

From the sql server's point of view there are no real problem, it's just slower than usual but given enough time it'll give you the...

If both DBs are on the same disk you might get timeout simply because the disk can barely keep up with the BCP in and has not much time left...

Are you using the SQL Server mirroring feature or are the 2 DB independent and manually synchronized?

Are the 2 dbs on different disks/LUN (using a SAN or direct attach)?

You could...

The transactional replication is the one way kind, the merge is a two way replication with some collision management (which can be easily avoided if the merged tables use uniqueid...

I guess we are not talking about the same kind of shared storage 🙂

Why do you need shared storage?

When you assign a SAN LUN to a resource group its only...

Did you set each partition to the correct filegroup?

The easiest way to do what you want (if you have the room) is to create a second table partitioned the way...

Database mirroring requires a very (very) reliable network as a 15sec lag (by default) will trigger a fail-over.

In your situation you might need something more resilient like replication if possible,...

The replication only requires both instances to be up, they don't have to be in the same resource group.

A resource group is just a bunch of applications and resources moving...

The snapshot will be an overhead of the mirror database yes, but the important thing is the performance of the principal. As long as the mirrored DB is not on...

Syed Jahanzaib Bin hassan (4/18/2011)

---

Transactional and snapshot Replication is best for your scenerio but mirror cant be use because you cant query to the secondary node if primary node is...

Actually there is a reason.

You just slap an MSDTC resource per SQL Server instance group. Each can be configured differently and will fail-over with their instance.

You don't really need a...

Grant the user "Browser" on the root directory.

Accessing the properties of a report seems to first check something in the root directory, if the user has no rights there he...

You'll need an index on it since none of your current index fits (the second is filtered).

As said above, if you need so many rows over so many columns, your...

Not telling anyone what to do 🙂

Just wondering why some folks used backup size, maybe the file size is harder to get in SQL 2000 or some other reason I'm...