so try restore headeronly...................:-)

But I have a query, What about content changes of Systems databases, like New Login, Server option change, New Job, Changes in Job Schedules e.t.c... How you handled that? Did...

are you trying to recover the standby database because you want to failover?

what does restore verifyonly of that log file say?

That last log will have failed to restore so database...

It would work fine, SQL won't care that the distribution database is in a different location.

However, if you stop replication by disabling the agents, ensure its quiesced and no pending...

I think you would have to stripe across separate drives so see good improvement, that's the recommendation if you are using striping to get faster throughput.

First thing, if this has only just started happening, anyone changed anything?

if it happens again run sp_who2, look for blocking, and check what the most common wait types are.

run a...

virtually the same? was it better at all?

I guess i would have expected it to be faster, perhaps 12 stripes was overkill and you got contention. They are all going...

But I have a query, What about content changes of Systems databases, like New Login, Server option change, New Job, Changes in Job Schedules e.t.c... How you handled that? Did...

you want restore headeronly.See BOL or

http://msdn.microsoft.com/en-us/library/aa238455(SQL.80).aspx

tip: if you want to know what commands EM issues when you use it, run profilwer filtered for EM events only while you perform the...

I'm talking about a windows group for use by a team of DBAs really. A new group would be created in active Directory by whoever looks after that, then that...

If you don't know the password there is no way we can guess it for you. When installing SQL server 2005 you have to specify a password so it will...

are YOU connected to the database when issuing the command?

Any chance you are using enterprise edition? If so you can use mirroring with snapshots rather than logshipping, which is not ideally suited to your purposes

see http://msdn.microsoft.com/en-us/library/ms175511.aspx

what does that script do? Security people LOVE...

that doesn' sound like an error from a third party enterprise tool.

This thread lists some ways to search for strings in your stored procs:

http://www.sqlservercentral.com/Forums/Topic695413-357-1.aspx#bm695503