sounds like you are tying yourself in knots trying to acheive this, which is always risky.

This might be one of those cases where looking into a third party tool which...

Can you take the hit of the full backup at weekends only and then go for differential backups during the week, or filegroup backups if you have more than one...

you cannot disable windows authentication, only sql authentication, which then precludes using the 'sa' account.

closest you can come to it is set up a domain account, use EM to alter...

yes

Also,...

A Joy (6/4/2009)

---

This should all occur on the tempdb (ie no file growth of any kind on the database itself as there are only reads occuring) until the write back...

That should only happen with SQL authenticated ids and restoring onto a different SQL instance. I presume this is your scenario.

use sp_change_users_login 'update_one','username','login' to tie the user up to its...

Books OnLine will be your best resource here.

search on these keywords:

authentication modes

create login

create user

fixed database roles

fixed server roles

sp_addrolemember

grant

USe a windows authenticated ID if you can. SQL authenticated ids have improved...

the leaf node of the clustered index is the actual data, so when you rebuild the clustered index you are effectively moving the table data around. Hence the large amount...

In a nutshell Its not worth the effort.

To expand on that:

mssqlsystemresource you cannot move anyway in 2008

master database has very little updating, so no performance requirement to separate logs

ditto for...

If you can afford the risk of it not working might be worth trying just restarting SQL, would be interesting to know if thats enough to clear the problem.

This gives the owner of the database

select suser_sname(sid),name from master..sysdatabases

just add the relevant where clause for a particular database

Retrieving who originally created the database (if different) I dont think...

a quick test shows db_datawriter does not have select permissions.

Gursethi, nice one, I did not realise that would work onto a new database.

My apologies , there is an error in the above post. You cannot use express edition as a logshipping monitor as it does not come with SQLAgent.

I was thinking mirror...

what error do you get? the...