Monthly Archives: February 2011

angsknarren 9:59 am on February 25, 2011  

Script för att ändra schema i SQL databas.

/* Genreate schema update script for tables with specific schema name */

USE TestDB

DECLARE @schemaName varchar(50)

set @schemaName = ‘guest’

select ‘execute sp_changeobjectowner ‘+ ”” + ”+@schemaName+’.’+name+””+’,’+”’dbo”’

FROM sys.tables

WHERE SCHEMA_NAME(schema_id) = @schemaName

/* Genreate schema update script for sp with specific schema name */

USE TestDB

DECLARE @schemaName varchar(50)

set @schemaName = ‘guest’

select ‘execute sp_changeobjectowner ‘+ ”” + ”+@schemaName+’.’+name+””+’,’+”’dbo”’

FROM sys.procedures

WHERE SCHEMA_NAME(schema_id) = @schemaName

/* Genreate schema update script for view with specific schema name */

USE TestDV

DECLARE @schemaName varchar(50)

set @schemaName = ‘guest’

select ‘execute sp_changeobjectowner ‘+ ”” + ”+@schemaName+’.’+name+””+’,’+”’dbo”’

FROM sys.views

WHERE SCHEMA_NAME(schema_id) = @schemaName

angsknarren 10:21 am on February 9, 2011  

Problem med Enterprise Vault filesystem arkivering

File System Archiving automatically configures the Internet Explorer settings so that the Web Access application computer is in the Internet Explorer trusted siteslist. File System Archiving checks this setting each time the file server is processed on an archiving run.

If the computer that runs the Placeholder service has incorrect Internet Explorer security settings, users cannot open any placeholder shortcuts. Each attempt todo so produces an entry on the Windows Application log on the placeholdercomputer, saying that there was an error downloading a file.

To configure the Internet Explorer security settings

  1. Log on as the Vault Service account to the computer that is running thePlaceholder service.
  2. On the Windows Start menu, click Settings > Control Panel.
  3. Double-click Internet Options.
  4. Click the Security tab.
  5. In the list of zones, click Local intranet.
  6. Click Sites.
  7. Click Advanced.
  8. Enter the name of the Web Access application computer, without the DNSdomain, and then click Add.
  9. Click OK.
  10. Click OK to close the local intranet settings.
  11. On the Security tab of the Internet Options dialog box, click Custom Level.12 Under User Authentication in the Security Settings dialog box, select eitherAutomatic logon only in Intranet zone or Automatic logon with current username and password.
  12. Click OK to close the Security Settings dialog box.
  13. Click OK to close the Internet Options dialog box.

Från Enterprise Vault Adminguide…

angsknarren 1:15 pm on February 2, 2011  

Ställa in maximalt antal aktiva databaser Exchange 2010

Setting Maximum Active Databases Limit On Exchange 2010 DAG Members… Many exchange admins will be a bit confused when it comes to designing an Exchange 2010 environment with large number of users and three or more copies of databases. The question is how to design the 2010 system to withstand the worst possible failure and still provide a good experience for the users during failover. One design recommended by Microsoft is to design for all database copies to be activated. For example, if you have 30 databases (active & passive together) hosted on one server, then the design should have processor and memory requirements for all those 35 databases to become active on the server during a failure. This is the best possible design but will be very expensive. Another approach recommended by Microsoft is to design for targeted failure scenarios. A simple rule is to design for automatic single node failure in a two node configuration, double node failure in three server configuration (manual activation for second failure) and for automatic double node failures where the DAG has four or more nodes. The appropriate number of database copies is required to meet each of these configurations and the copies be randomly & evenly distributed. In this design approach, it is recommended to restrict the number of databases that can be activated on a server during a failover, so that the server doesn’t activate more databases than it was designed to handle and thereby giving a very poor user experience. You can configure a hard limit for the number of databases that can be activated using the cmdlet below. For limiting the server to 25 databases, run Set-MailboxServer –identity “servername” –MaximumActiveDatabases 25 When the maximum number is reached, the database copies on the server won’t be activated if a failover or switchover occurs. If the copies are already active on a server, the server won’t allow databases to be mounted. This is something that needs to be looked into while designing a highly available, high performance Exchange 2010 environment.

http://www.howexchangeworks.com/2010/02/setting-maximum-active-databases-limit.html

angsknarren 12:51 pm on February 2, 2011  

Xenserver Virtuella Nic

Realteak RTL8139C + FastEthernet NIC. Utan Xentools
Citrix PV Ethernet Adapter. Med Xentools (xennet6.sys)