Along with what steve said, I would also add that some registery entries wont be done properly if you use services to change the account.

Backup can be done for specific file groups. Check BackUp Database in BOL for file group back up for more details.

Example

BACKUP DATABASE Sales

FILEGROUP = 'SalesGroup1',

...

As per almost all experts, this is what they all say..

The only way to ensure that you can restore the databases when you need to is by testing the backups....

We had the same issue. Basically you would get query timeout or General Network errors. This happnes when you have website pages that open connection and does not close it....

Guys and ladies, I am an Indian living in the Carribean. The caste system is still there but not like how it is preceived in teh outside worls. Actually now,...

If it is DNS Caching then you can just type in ipconfig /flushdns and a ipconfig /registerdns. This will flush all the cached DNS info and then re register the...

When the DNS was changed, was the server name also changed?

This is what I read on another site.

affected areas:

1. linkedservers

2. replication

3. logshipping

4. applications connecting to the server

5. possibly firewall...

I got this from another site. This might help you in the future as well...

ERROR STATE

2 and 5 Invalid userid

6 Attempt to use a Windows login name with SQL Authentication

7...

The error state 12 indicates that your sql account has no access to the server, have you grant login to it? Can you also try connecting over named pipe, what...

You are welcome. About SQL 2008 Compressed back up, it wont work for me since the Business wants to use TDE. With TDE, compression for compressed back is is next...

Bob Hovious (3/4/2009)

What you have to love about all these rules are the total absence of examples, or explanations about "why". It's possible that he really...

Do you know if it is blocking or locking. First thing I would do is to set up the start up poarameters with -t 1204. This will write the Dead...

Derek Dongray (3/4/2009)

---

They must be giving out MVPs with breakfast cereal these days!:D

I've looked at some of his recent responses on MSDN and a lot of them seem to be...

Question from lynn is pretty good. Maybe then I too can become a MVP in such a short time as well. 🙂

With my knowledge base, NO CHANCE AT ALL. But...

I dont think he still realizes that he was rude. I guess when he looks in the mirror, he sees two wings on his shoulder blades and Halo over his...