At the FIM Birds of a Feather (BOF) after a discussion about FIM database backups I was asked to make a blog post to more fully elucidate the benefits of using the full recovery model. Since Recovery models affect the transaction log you may find it useful to have the following background about transaction logs: •The Data in tables and indexes are stored in data files not the transaction log
As for me why no posts since Nov 11th – well, I have attended the Live@edu Partner Airlift in Redmond, SQL PASS, had a flat tire, and enjoyed Thanksgiving. In this post I attended the Live@edu Partner Airlift in Redmond to see what’s new under the sun for schools and universities. Exchange Labs is now available on a widespread basis (see fellow MVP Almero Steyn’s blog posts on Live@edu and on Exchange Labs) !
I posted the following to the Community Content Section of the ILM 2 Beta 3 Installation Guide The SQL Agent Service account must be a sql sysadmin and the SQL Agent Service must be running or during install you may get “error -2147217900 Failed to execute sql string addtemporaleventsjobtoSQLServer” while trying to install ILM 2 Beta 3 Identity Management Platform Services. Apparently, the install routine needs to create a SQL Agent Job and with SQL 2005 the Agent must be running to create a job.
Hi, I’m installing SQL Server 2005 in 2 node … Unknown - Jun 3, 2010Hi, I’m installing SQL Server 2005 in 2 node cluster setup and I’m getting the below error: TITLE: Microsoft SQL Server 2005 Setup -—————————– SQL Server Setup has determined that the following account properties are not specified: ‘SQLBROWSERACCOUNT’ . The properties specify the startup account for the services that are installed. To proceed, refer to the template.
Some of you may run into a problem when installing a multi-instance SQL Server Cluster, in particular when you install the second or third instance in your cluster. Like this one: Microsoft SQI Server 2005 Setup SQL server Setup has determined that the Following account properties are not specified: ‘SQLBROWSERACCOUNT’. The properties specify the startup account for the services that are installed. To proceed, refer to the template.ini and set the properties to valid account names.
Congrats to the SQL Server team for shipping 2008. It looks like a great product. Congrats as well for keeping the licensing costs the same and adding a new option with the web edition. One question that many still have in mind is how to license SQL server. Processor licensing allows unlimited users and devices, whereas a server license allows unlimited users or devices as long as they have a CAL.
Hopefully this topic will stir up some excitement among those wondering how to query objects in the connector space. The technique I am about to explicate for you works for both exports and imports. As many of you aware, my colleague and fellow ILM MVP Brad Turner created the community reporting pack for MIIS/ILM some time ago. This is a package of reports written in SQL Server Reporting Services (SSRS).
For years developers have had access to the Microsoft Message Queue (MSMQ) as a way to be able to queue up actions for processing later or on a remote machine. With the release of SQL 2005 back in well 2005, developers with access to SQL 2005 could replace these MSMQ apps with SQL Service Broker Queues (SSB). With ILM 2007 /MIIS 2003 SP 2 supporting SQL 2005 the use of SQL Service Broker Queues became much more accessible to ILM Developers.
