I believe the technical term for the above is what we call a 'right palaver' 🙂

I wonder if microsoft realised the effect on DR procedures when they disassociated SSIS...

I wouldn't drop an ldf because log backups are failing, that way heartache lies. Run a dbcc checkdb on the database.

Is the log growing if the log backups are failing?...

make that tranlog backups, full backups do not truncate the log.

definitely agree that in the good old mainframe days unit testing was a de rigueur phase of the development cycle.

In these days of rapid development, time to market and dare...

do you have third party enterprise backup tool backing up to virtual device? These can cause these messages when the database is momentarily 'frozen' for the tool to complete the...

the 'virtual device' gives it away, thats is definitely a third party enterprise backup tool such as veritas backing up the database. Talk to your sysadmins or network admins.

the nodes don't have to haver the same config in terms of no of cpus, RAM etc, but what the trainer was probably trying to get across was that each...

the -1 message from the rebuild means it failed as files are read only, so are system db files in place now? Are you sure it worked. Normal workaround is...

just to note, re-copy whenever you upgrade. I usually have two copies on the go, current and previous versions.

check out DBCC traceon and traceoff

to do it at start up time add -T options via configuration manager

no bother, glad to hear you sorted it.

I still recommend doing a flat file copy of your system dbs, save having to worry about rebuildm.

edit: typo

its been a while but IIRC rebuildm is looking for the files from the install disk, that is the system db files in folder x86\data.

There was a bug with this,...

good point David, how about disallowing spaces in object names as well?

I came across a database the other day where the logical filenames were:

this is the database data file for...

this works and is perhaps easier to read?

ALTER TABLE YourTable

ADD CONSTRAINT ck_oneorother CHECK ( (col1 is null and col2 is not null) OR (col1 is not null and col2 is...

Upgraded from windows standard to enterprise? I thought that was a reinstall, therefore you would have to reinstall SQL.

the install directory looks weird, MSSQL.1\MSSQL\DATA\ directories appear to be replicated? Are...