pauls2

see http://support.microsoft.com/kb/916287

Judging by previous replies I will be controversial and say NO to SQL 2000 SP5. I think it is widely accepted that 8.00.2187 is the roll up to go to...

SG, if I understand correctly, you do not have a backup of the msdb databse, but you do have the mdf and ldf files from some time in the past...

run a log backup and see what happens..................

a log file is made up of virtual logs, and will only shrink down to the last virtual log with active transactions, yours must be at the 73GB mark.

run the...

chris, did you add the file via SSMS? In the background that is using the 'Alter database ' command. You use that command to add a new filegroup as well....

it's simpler than you think:

script out replication first (just in case and so you can easily recreate)

quiesce replication (including all check agents that access distribution database)

check no commands to be...

sounds like the security police have been in with their tick list.............

how about revoke any access to these from public, if something needs one to work, create a role on...

Mark (1/23/2008)

---

Steve,

Ok, if I connect to integration services on my specified sql server where my maintenance plans reside and then expand 'Stored Packages', 'MSDB' & 'Maintenance Plans' I can see...

Ray, basiscally you are correct.

You will never be able to recover (as oppose to restore) your databse because it is a FILE backup from a different database, so there is...

you are right, you have been sent a partial backup of the .mdf file only. to restore you also need a backup of the log file.

I would get back to...

I think SQL believes you are trying to do a partial restore.

Take out the line filegroup = 'primary' from your code and it should work fine

well, looks like I flummoxed the SQL world again 🙂

so I did some digging and testing:

default database roles (db_accessadmin etc) are created with a schema, and although a new role...

if you have already instsalled SQL, you can change the collation using setup. See BOL under 'how to install sql server 2005 from the command prompt' then section 'To rebuild...

I see you are trying to start sql in single user mode, did you have a problem before causing the need to do this?

What happens if you try and start...