In the most cases there are benefits when all data (log and db) files are on the network storage. Think off the benefit in terms of performance and backup. The Install wizard of Microsoft SQL Server 2008 shows only the option to change the path of the temporary database. In this guide I show you how to move the databases. Please keep in mind to create a backup of your db’s before starting. I know backup is only for hot shower takers, gym bag losers and armpit hair blow-dryers;-). On my test server the path looks like:

Administration, Software 2007, ldf, master.mdf, mdb, server, sql

One of the hard tasks in the daily live of an IT administrator is to ensure that the network and the server are secure. The perfect security is not possible. There will always be some small leaks either provoked through the behavior of the user in version 1.0 or the administrator of the system. Not to mention design leaks in the software itself. Most environments are too large and too complex for a manual checkup of all security patches and service packs. One other factor is most users need some higher rights on their machine to do their work. This often results in disabling the windows firewall. These two scenarios are big the root of all evil.

Administration, Security MSBA, Security, server, Windows

Part One. Today and in my next posts, we want to take a closer look at the security settings of windows server. One good way to start is the “Security Configuration Wizard” later called as SCW. The wizard was patched in the operating system with SP1. In the release 2 of windows server 2003 you don’t need to patch – it’s from start up SP2.

Administration, Software 2003, Baseline Security, scw, Security Configuration Wizard, server, Windows