Now, helpful bit out of the way, I'm not going to laugh at the network engineer getting stuck with the DBA job, that happens, but I will laugh at the...

There isn't an easy way to do that...A SQL 2008 database won't restore / attach to a SQL 2005 server. You would have to script the table structures, data,...

Bhuvnesh (7/9/2010)

---

Jason Shadonix (7/9/2010)

---

Whats the benefit you got with...

I keep my log file size in check by running this every hour on my mirrored servers. (You'll have to modify the backup command to not use compression if...

Ratheesh.K.Nair (7/9/2010)

---

Jason Shadonix (7/8/2010)

---

OK, what am I missing here? Why are you thinking you need to stop mirroring? Just take a log backup and truncate the log if...

Bhuvnesh (7/8/2010)

---

The reason to stop mirroring is : if i rebuild the indexs of larger tables, log will grow tramendously.and same size (log) will be replicated to report node also....

OK, what am I missing here? Why are you thinking you need to stop mirroring? Just take a log backup and truncate the log if it is too...

Why do you feel that you need to remove mirroring to do this?

I shrink log files all the time for databases that are participating in mirroring.

GilaMonster (6/15/2010)

---

Will you please read what I'm saying...

GilaMonster (6/14/2010)

---

For reasons that have to do with the way the first few pages are allocated, there's virtually no point in rebuilding an...

Yes, That's what...

sabarish (5/3/2010)

---

Hi Everyone ,

We need to implement a datbase back up statergy for one of clients ... Some of the requirements mentioned by the client are as given...

aqkhan_k (4/29/2010)

---

When a publication database is mirrored, Log Reader Agent behavior is governed by the mirroring state of the database. By default, the Log Reader Agent can only replicate log...

Aw man! You sunk my battleship!!

Perry Whittle (4/29/2010)

---

Lynn Pettis (4/29/2010)

---

Since you are not using a witness, if the mirror databaseis unavailable, the transactions will get committed on the principal database. This will start approximately...

Also make sure there isn't a firewall that is blocking the TCP port SQL is running on. (1433 by default)