When I receive the "Cannot generate SSPI context" it is when my domain account is locked out for some reason (another story) and cannot be authenticated. Was the...

Is there already an earlier backup of the same name at that location?

I hope that's not the actual password you're using other places.

I undersand what you're going through. While my fellow DBA and I have admin access to all the servers we need, it is not unusual for a network...

I don't like the idea of killing jobs midway. Depending on what they do, partially completed jobs might be problematic.

I'd prefer to disable in advance any jobs that might...

Be careful with log drive space when upgrading VCenter. Our adventure last week was a VCenter upgrade that kept growing the VIManage.ldf file until it filled the drive. ...

Perry,

The steps I used were pretty much what you have in your article except that I used sp_helpdb <databasename> rather than sys.master_files. Does this make a difference?

I looked at...

I was pleased to discover that while SQL Server R2 Express cannot create compressed backups, it can restore compressed backups created on Standard ot Enterprise Edition.

I would add that if a default backup directory was not deliberately set when SQL Server was installed, then the default backup location is on the C: drive. ...

Attached a series of messages from SQL Log. All I did was take the DB offline, run an ALTER DATABASE command to change the location of the log...

Then why would my simple recovery model databases not come online with copies of the original log files in the new location?

If one or both of the database is very large you might get better performance by having two databases and putting them on separate drives. You can probably...

To minimize read-only time, I'd change the order a little.

1. Full Backup

2. Copy backup to new server & restore with NORECOVERY

3. Set to read only

4. Differential Backup

5. Copy differential...

Question: If you run this command

RESTORE DATABASE databasename WITH RECOVERY

after a RESTORE WITH NORECOVERY as shown in GilaMonster's post, the database will change to a normal state and you're ready...

Here is a script I use to look at available drive space where database files are located:

sp_helpdb databasename --< Name of DB here

/* This runs on SQL 2008...