Could be to do with your config file. Have a look at this:

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

John

You need to add extra logic to the CREATE LOGIN section of your script to obtain the SID of the new (or existing) login. Then, in the CREATE USER...

Doug

Are you saying you clear out the log before you do the restore, or after? There's no point in doing so before, since the restore operation will plonk an...

Still makes me think it's permissions. When you start the service interactively like that, it runs in the context of the account you're logged in as, not the service...

In that case, I'm stuck. I would recommend that you get hold of a utility by Microsoft (I think it's called sysinternals) and run it while you're attempting to...

There are only two reasons I can think of for this:

(1) Another full backup was taken between the first full backup and the differential

(2) The differential backup is actually a...

OK, so it works under Local System, which means it can't be pointing at the wrong location. I'm still guessing that whatever service account you are using doesn't have...

Didn't realise that, but when I think about it, it makes sense. Thanks for clarifying, Gail.

John

Do you mean there is no file created, or that a blank file is created? Check that the location for the...

Gail's point about shrinking the log was going to be my next question. But if you have a good reason for doing this, you need to check that the...

That's a strange restriction. Are you at liberty to explain? One way round it is to grant INSERT, UPDATE and DELETE on the schema(s) that contain your tables.

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

John

Not sure I understand this. Can you not just query sys.databases?

John

Rajesh

As far as I know, you can't have the same SQL Server job running more than once at any one time. If you are only ever going to need...

Adam Seniuk (8/16/2012)

---

Also when installing I found it easier to install with default accounts then go back and reconfigure the services with the AD accounts, any one see issues with...

If there's no primary key, there's no reliable way of preventing duplicates. The first thing to do is to import from your text file into a staging table, and...