If the Fileover / Reboot / Failover doesn't resolve the problem, I will open a ticket with MS. It's just an inconvenience for me, but it's a production server -...

Steve / Lucky,

everything looks good on the cluster - no failovers, time is good all around - everything is successfully synched up on the time servers, I'm still in the...

So far - Service Principal Names are not the issue, the servers all have the same times, AD changes are not the cause either. We are going to move the...

Thanks, ALZDBA, I'll check into that, and leave a reply on whether thats the issue or not.

Sugesh - I'm not sure what Registry permissions you are referring to ...

ALZDBA - the SPN seems to be fine, I think, can I get a little more detail on...

Ray, thanks for the thought - I already tried the logoff / logon maneuver, it didn't help. If my AD account was locked - I wouldn't have been able to...

We are interviewing for a senior level DBA right now, and (same as other comments) its amazing how many people can write up a storm on their resume / cv,...

Andras,

Excellent. Thank you very much.

Simon.

Its been a few years since I worked with Sybase, so this is really just thinking out load, but ...

When you create a linked server, you're actually connecting to the...

We've been interviewing for DBA's recently (anyone in Denver want a new job???), and a couple of the candidates were very proud of their MCDBA's and MCITP's, but didn't have...

After I got it wrong, I had to look this one up - http://msdn2.microsoft.com/en-us/library/ms190729.aspx - 'For log backups, the first LSN identifies the first log record included in the backup....

We had the same problem - 80+ servers, 800+ databases. I also went with Pull architecture, but everything is run from the data warehouse server (SQL 2005) using dynamically created (created...

Eric Peterson posted a nice stored procedure to handle defragging / rebuilding indexes in this months SQL Server mag: http://www.sqlmag.com/Article/ArticleID/96059/sql_server_96059.html. I won't publish his code here, it's not mine...

I had the same problem a while ago. I was lucky that my first step was to backup the database. I stopped SQL, deleted the MDF and LDF files, restarted...

You can't restore a Diff. backup to an online database. You will have to restore the Full backup (WITH NORECOVERY), then restore the differential backup (WITH RECOVERY).

You only restore a...