Hi,

here you are:

alter database TEST1  set SINGLE_USER

Yes, you are absolutely right! Your DB isn't in the single user mode

This command sqlservr.exe -c -m is used for restoring master DB and therefore you need to  put SQL...

Are you sure that you don't need domain account in this scenario? As I see you are using  NT AUTHORITY\SYSTEM account...

How many servers have you involved in log shipping?

Which server...

Well I know one tool but never used.

http://www.sql-server-performance.com/log_explorer_spotlight.asp

Are you looking this one?

Hope this helps

You can read the following regarding to your problem:

http://www.support.microsoft.com/?id=110139

Maybe it's first step to dba? If you are a newbie on SQL Server the real dba doesn't want you to permit all...

Great trick. Yuri I suggest you to read article in the link till the end

Yesterday I've restored one DB from 6GB backup file. It took near 3-5min. Backup was on the same server and the server is fairly powerfull(this year production).

Keep calm... Wait a...

Agreed with dcpeterson. Someone, who has system administrator or security administrator permission revoke sa permission from you. I think that from all scenarios that could be, this explanation is the most...

Glad to help. Sometimes a minor detail can stultify a huge job...

Cheers

Well, the work (and script) amount depends on your columns number. If you had a lot of them then I suggest you to write cursor which brings you table and...

Are you sure that your live server SQLAgent account has necessary permisions to reach outside resources? If this job works on one server but doesn't on the other then there...

On my opinion msdtc.exe comes with windows not with sql server install. So if you don't have it then if you want it simply install

I'm sure there was a KB...

First you must have these copies. You can not atach these files if they depend to original DB. They can not be shared to other DB at the same time

Thank you Phill, it could be a solution of my problem. I have a couple days to fix it and if I don't find the correct answer to my problem...