Thanks!!!

Problem solved thanks

Hi Dave in order for domain group/users to get access they will need to have appropriate permissions to the sqlserver.

This will help explain

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_security_5hrk.asp

I used the alter database but now I cannot apply any logs or diffs to the database.

Edited by - growl on 10/14/2003 01:30:57 AM

Edited by - growl on 10/14/2003...

quote:

---

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/awarren/terminalservicesacoupletips.asp

---

We use...

What about creating another role with select only on thE relevent msdb tables?

Edited by - growl on 10/02/2003 10:24:44 PM

To bring the standby database out of read only execute the following

restore database <<database name>> with RECOVERY

Make sure you have applied all the necessary transaction logs/differentials beforehand! Because once...

Please ignore. I have found the answer

Thanks

Hi Brian I found this very useful.

http://www.databasejournal.com/features/mssql/article.php/2228611

Microsoft has also some info in there knowledge base

http://support.microsoft.com/default.aspx?scid=kb;en-us;246133#4

Cheers

Here here. Litespeed is a saviour!

The size of the transaction log was 3 gig.

Pointing all alerts to this box and is setup as a secondary server.

What's the size of the database?

If you are doing this on a regular basis.

Invest in Litespeed.

Biggest database we have is about 30 gig.

With litespeed the backup is 3gig.

No replication

No active open transactions.