Personally, I prefer to use CharIndex when you need to find a simple string with no pattern matching. Otherwise, I prefer square brackets over the escape clause.

The reason you need...

There is no difference in licnesing between 64 bit and 32 bit. If you are using processor based licensing, your license must be for the larger of the two machines....

There is an easier way to do this. Just use xp_enumerrorlogs.

See my blog post on the subject: Error Logs: Part Two

Also see Error Logs: Part I which also shows you...

Steve Jones - Editor (4/10/2009)

---

I wouldn't care except that I can't get a "list" of MVP names from MS. Despite the fact there's a crappy web listing of MVPs, I...

WILLIAM MITCHELL (4/10/2009)

---

Examples of good advice:

The reply indicates that the poster fully understands your question.

If the poster does not fully understand your question, they ask for clarification or relevant details.

The...

I'm not an MVP, and I couldn't really tell you what it takes to become one. But I know from my years working at Microsoft that Microsoft takes the MVP...

Just a thought, but does the database have a full text catalog that you're not counting in the size of the datbase but is in the backup?

There is no difference in the database files between 32 bit and 64 bit so you can mix and match architecture in any configuration.

Like Matt said, you're going to take...

My blog is at: http://www.sqlservercentral.com/blogs/robert_davis/default.aspx

Mohit (3/30/2009)

---

Robert Davis (3/30/2009)

---

No, technically it is not offline, but that is the error that the maintenance plan's job used to return when it tried to backup the restoring database.

Based...

francis (3/30/2009)

---

In regards to my suggestion to map the Admistrator/sa to the new SID, the new box/server is just for testing purpose and it is an individual body by itself....

Mohit (3/30/2009)

---

Hmmm I heard they changed it in one of the SP; but my backups been working successfully. I'll get back to you on that...

But I will note databases...

Mohit (3/28/2009)

---

For backups, use Maintenance plans ...

- The maintenance plans are intelligent that is, if the database is mirrored partner it will all database that are set as mirroring even...

FYI: I referenced this article on my blog: http://www.sqlservercentral.com/blogs/robert_davis/archive/2009/03/29/Do-You-Support-the-Ancient-Ones.aspx

By your description above, it sounds like you are not using a witness server. As such, I am assuming that you are running mirroring asynchronously.For this setup, there is a...