If this issue reported is on production box, I would recommend upgrading MSSQL server to the latest and greatest SP and HF on test box just to check if the...

Dear Friends,

You can delete your own login when you are logged in 2008. It throws below error.

“Deleting server login does not delete the database user associated with logins and...

Out of my experience I have couple of more things that can be added to monitoring checklist.

Backups

It is very important to check integrity of the backup files. Once in a...

Hi Steve,

Your lines below are very impressive and makes DBAs to think twice before they make decision weather to stick back to same role or change role to explore more/new.

"They...

Out of my experience I have couple of more things that can be added to monitoring checklist.

Backups

It is very important to check integrity of the backup files. Once in a...

Hay Steve,

Nice article motivating everyl level of technical people.

Basic question, but still good one.

Hi Balaji,

What is the Db size by the way? And by when are you planing to migrate to Oracle? More appropriate solution depends on these questions. Also I am growing...

Try to expand databases through SSMS or run some simple querry againest STSQLSERVER3, I am sure it should throw error message.

Hi,

I feel No recovery is mode is purely requirement based.

One of the scenarios I think of not using Standby mode is, if you are running other realtime applications on...

Can you please post error message if any?

Also, please try enabling Named pipes protocol in SQLServer Configuration Manager.

- Cool_Ice

Don't drive faster than your guardian angel can fly ...

Very interesting question… It initiates lot of investigations 🙂

-Samji

If I copy and paste the script in query analyzer and bulk execute it, probably I would have answered it correct.

But when we walk through the script, anybody assumes...

Hi Sanket,

May I know which version MDAC are you using on this server? If you are not using MDAC older version, please try to upgrade it to MDAC 2.7 or...

Try this...

RESTORE FILELISTONLY

FROM DISK = 'CompletePathOfbackupFile.bak'

Once you get the logical file names

RESTORE DATABASE DB_Name

FROM DISK = 'CompletePathOfbackupFile.bak'

WITH MOVE 'logical name restored from first statment'...