[THIN] Re: SQL Best practices
- From: Seán <pne1881@xxxxxxxx>
- To: thin@xxxxxxxxxxxxx
- Date: Fri, 3 Jun 2005 08:59:21 +0100 (BST)
Many thanks Henry...in its own database to be sure!
I'm thinking of using a Simple Recovery Model: ie minimal logging.
Has anyone used the Simple Recovery Model? I'm wondering what happens
if the Data Store is restored under these circumstances. The important
data, Licencing, Published Apps etc. are essentially static but what
about connected sessions? Will they be rebuilt (I assume so).
- Seán Carr
>Henry Sieff wrote:
>
>DEFINITELY do not try to put it in master. Master, model, temp and
msdb
>are special and should be avoided.
>
>In most cases the defaults are fine - you want to decide whether you =
>need to do Point-in-time restores (restores using transaction logs).
If
>not, you can safely set database recovery model to simple.
>
>Tlogs and data location should follow the general settings of your sql
>=
>server, without a compelling reason not to. Make sure you add it to =
>existing maintenance jobs (backups, optimizations). Other than that, I
>=
>just followed the citrix instructions.
___________________________________________________________
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail
http://uk.messenger.yahoo.com
********************************************************
This Weeks Sponsor: ThinPrint GmbH
Now available: The new version .print Engine 6.2 with SSL encryption
and certificate management.
http://www.thinprint.com
**********************************************************
Useful Thin Client Computing Links are available at:
http://thin.net/links.cfm
ThinWiki community - Excellent SBC Search Capabilities!
http://www.thinwiki.com
***********************************************************
For Archives, to Unsubscribe, Subscribe or
set Digest or Vacation mode use the below link:
http://thin.net/citrixlist.cfm
Other related posts:
