Why not just set it to run every minute for now, and then you can monitor it over the 30 minutes, rather than having to wait until later?

Ok, that's helpful but we need to go through it step by step as there are so many variables.

Are you taking transaction log backups outside the log-shipping environment? If so,...

Can you tell us what the exact error message you're getting is?

When you say you're running it every 24 hours do you mean the backup job, the copy job and...

[dup]

Hi. You don't actually need to create a new database before you do the restore, so you could drop the one you created, which would simplify things.

[dup]

Your systems/SAN/infrastructure whatever you call them team may well have decided to take your SQL backups for you. They sometimes do this :-D.

Under these circumstances you need to talk to...

Why do you want to shrink it? It may be that that is the size it needs to be.

Yep, you can just restore it. You can't go the other way round (e.g. 2012 to 2008)- maybe that's what you were thinking of.

No, as already been said, you...

[more effing duplicates, sorry]

It's available in Standard edition if you're running 2008 R2 or higher:

http://msdn.microsoft.com/en-us/library/cc645993%28v=sql.105%29.ASPX

Have you tried

use master

go

alter database yourdatabasename

set restricted_user with rollback immediate

then trying your restore?

[dup]

Really? There's nothing else at all?

Does the wizard come up at all, or does it error straight away?