any DENY permissions override grants. Have the users been added to another group which has DENY permissions on the object?

sp_help tablename

interesting. This is the second thread on this subject. according to MS this option should be available. Have you tried applying SP1?

each log backup will contain discreet transaction information. They are not cumulative like differential backups, they are consecutive,

the first log backup will contain committed transactions up to the point...

good point.

Garbage in, garbage out OR garbage backed up garbage recovered

also the ability to build a delay into log shipping is an oft forgotten advantage of this old workhorse...

is the database in simple recovery mode? Needs to be at least bulk-logged for log shipping.

Mark Schurmann (7/16/2010)

---

I think I came to the same conclusion on the system databases. As for the ReportServer databases. I did not stop the Report Server before for...

these are the instructions on how to do it in an emergency

http://msdn.microsoft.com/en-us/library/ms345408(SQL.90).aspx

- but my advice to you is if you dont have to, DON'T.

this is a bugbear of mine. Do not try and separate the data and log files for system databases. They are almost exclusively read only databases so you gain nothing...

@Gail

Plus, since the kitchen faces South-West, it gets very little sun except late in the afternoon. The bedroom, with wall-to-wall windows facing NE is a fair bit warmer, so's the...

what recovery mode is the database in?

I really, really knew the answer to this, but it seemed so simple and obvious I thought there must be a catch and didn't answer it.

I think I am suffering...

In a nutshell no.

the only thing that might look like you have is in log shipping. Take a tail log backup, this leaves the database in recovery.

apply this log backup...

ISAM is a type of File that can be queried, Used a lot on mainframes in the good old days.

Still might be for all I know.

no way, its appreciated. Its those that never get back to you to let you know how...