Moving WSS 3.0 Databases
Tuesday, November 18th, 2008 | Tech Help | No Comments
WSS 3.0 uses Microsoft SQL Embedded Edition (MSEE) for its data store. When MSEE is installed, the data files are installed to your C: drive by default. Since you do not want to have a file on your system drive that can grow exponentially, you need to move it to another drive. Here is how you do it.
Note: While completing this process your WSS site will be offline to your users.
- Shutdown all Windows Sharepoint services & IIS Admin service: This will ensure that there are no locks on the files you need to move.
- Open a cmd prompt and cd to C:\Program Files\Microsoft SQL Server\90\Tools\binn
- Enter sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E: This starts the Microsoft SQL Server 2005 Command Line Query Utility
- Enter the following commands to view the available databases & hit Enter after each:
- SELECT name from sysdatabases
- GO
- SharePoint_Config_c464b7ce-59ef-4820-9f75-f46a0937c08e
- SharePoint_AdminContent_451452bf-9dc0-40c9-be18-14f14bc23007
- WSS_Search_NETSERVER_86a140c5958d4a5d97c8c2cbee745424
- WSS_Content
- Enter the following commands & hit Enter after each line. Repeat for each database.
- EXEC sp_detach_db @dbname = ‘Content_Database_name’
- GO
- Move the databases to their new location. They can be found in C:\Windows\SSQL\Data\
.mdf and_log.ldf - After the files have been moved run the following commands (Make sure to change the itialic sections to your specifics):
- EXEC sp_attach_db @dbname = ‘Content_Database_name‘, @filename1 = ‘drive:\path\Data\
.mdf’ , @filename2 = ‘drive:\path\Data \_log.ldf’ - Go
- Repeat step 7 for each database you moved.
- Restart IIS Admin services and all Windows Sharepoint services
- Ensure your Sharepoint site is working
You should see a number of DBs, move the following 4 databases (GUID’s may be different):
If this is done before you build your site it will take no time at all to move the DBs to the new location.
Moving Pictures…
Friday, September 12th, 2008 | Baby News, Life | No Comments
Three more videos of our little monster.
For your viewing pleasure
Friday, September 5th, 2008 | Baby News, Life | No Comments
Here is an old video of Keely at about 2 months old:
This one is from a few weeks ago during our visit to Thunder Bay:
More Registry Goodies
Wednesday, July 16th, 2008 | Tech Help | No Comments
We are in the process of installing a policy and procedure management application at the hospital. It has been setup so that users are not required to enter their user name and password to access the site, it is done via LDAP. To get the single-sign-on benefits of the LDAP look ups we needed to add the domain name to the list of trusted sites in IE. This can be done via Group Policy, but, my experiences with this group policy setting has been mixed. Each time I configured this Group Policy Object setting it turned off the option for the user to add sites. Each new site needed to be added by me in to the GPO. While I limit what my users can change and access I do not like getting calls for simple stuff like this. What was I to do?
Set the IE homepage via the registry
Friday, July 11th, 2008 | Tech Help | No Comments
We just got in a batch of HP desktops and so far they look to be a good investment. There isn’t much crap/bloat ware installed on it, so we can get them out the door to our users quite quickly. We have had only 1 minor issue with them. For each new user who logs in, the system sets the IE homepage to an HP/AOL site, not our corporate intranet. Instead of emailing our users instructing them on how to set the homepage back to our intranet site I logged into our Desktop Authority server and added a new option under the registry settings.
IT Humour
Thursday, July 3rd, 2008 | Life | No Comments
After years in the IT field, I have seen incidents and users like this. I laughed my ass off when the IT guys goes into his boss’ email and deleted the DO NOT REBOOT THE WEB SERVER!!!!!!! email.
IT Guy Vs Dumb Employees - Watch more free videos
The guys/gals that produced this gem should win an award.
Firefox v3.0 First Impressions
Wednesday, June 18th, 2008 | Tech Help, Tech News | No Comments
Browse Safe with Firefox 3
Firefox 3 was released yesterday to much fanfare. The first tallies are showing over 8 million downloads in 1 day. Of that total 269,901 were by Canadians.
Update June 19: Download total is now over 11 million, 320,000+ by Canada.
I’ve been using it for about a day, here are my initial impressions.
I don’t have any stats to back it up, but Firefox 3 seems faster. Pages come up fast, there is very little lag when switching tabs and so far the memory used by Firefox 3 is not growing by the second. Now I never had the memory issues some users of Firefox 2 have had, but, I regularly have 8-10 tabs open a time, often even more, and Firefox 3 so far seems to hang around 120-140K. Much like my old install of Firefox 2. This may be because I keep the amount of add-ons I use to a minimum, so I was never affected by the memory issues.
After installing Firefox 3 the first thing I noticed was the update interface. Thankfully Mozilla didn’t mess with the standard browser placement like Microsoft did in IE7. I also noticed that a new folder showed up on my toolbar. Firefox 3 adds a “Most Visited” folder. I’m not sure if i will use it yet, but could see how it could be useful.
I’m still learning & playing with all the new features in Firefox 3, and getting used to the new url bar, but, so far I like the new version. This is a required upgrade to all Firefox 2 users. I also strongly recommend IE users to take the plunge and give FF3 a try. I really think you will be impressed.
US Style DMCA Proposed in Canada
Tuesday, June 17th, 2008 | Tech News | No Comments
On June 12th the first reading of Bill C-61 took place in the House of Commons. This is a terrible bill that takes the power of copyright law out of the hands of lawmakers and into the hands of corporations. I’ve gathered up a few links to get you up to speed on the issue. You can read them here, here & here.
You can get a simple form letter to e-mail your MP here. After e-mailing your MP make sure to drop a copy of the letter in the mail, no stamp needed, to;
Your MP’s Name
c/o House of Commons
Ottawa, ON
K1A0A6
Completing the process takes no time at all. Our MP’s need to know that Canadians will not stand for this loony law. Check out UserFriendly’s cartoon strip for a slightly humorous slant. June 16th & June 17th strips.
Who is a failure?
Monday, June 16th, 2008 | Life, Tech News | No Comments
Everything that I had read said that Google had adjusted their algorithms to combat link bombs, also known as Google bombs. Turns out this may, or may not be the case.
Head on over to Google and search for the term “who is a failure?“. The #1 result should look like the photo below.
This story originally broke back in February. Perhaps this isn’t a true Google Bomb, and is just an unfortunate coincidence for Mr. Bush.
Wayback Machine Fun…
Sunday, June 15th, 2008 | Life, Tech News | No Comments
I stumbled upon the Internet Wayback Machine today. It was great fun looking back a the early days of the web. Google, MSN, NBC, CBC have all come a long way since the static web pages that we were treated to in the late 90’s.
MSN then:
And Now
Popular Posts
Recent Photos
