Oh, switching topics.

We had the best Mongolian BBQ place in town a few years back. Now it's gone. I miss it so much. I need to track down a new...

But...you can be sneaky and use windows schedules tasks to get around that "limitation" if you really need to use Express edition.

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!!