Browse by Tags

• MOSS 2007
• WSUS

• Backing Up User Databases in SQL Server (and SQL Server Express)

  Since I appear to be on a roll with my blog this morning, I figured that I should write one more post about SQL Server before I get back to my "day job." I typically use SQL Server Management Studio to configure and schedule database backups, because Read More... Posted Friday, May 30, 2008 8:22 AM by Jeremy Jameson | 1 Comments Filed under: SQL Server, WSUS

• Counting Rows in All Database Tables in SQL Server

  Here is yet another of the SQL scripts that I like to keep handy in my toolbox: Count Records in All Tables.sql Sometimes when I get "dropped into" a consulting situation with a new customer, I need to quickly get acquainted with one or more of their Read More... Posted Friday, May 30, 2008 7:56 AM by Jeremy Jameson | 2 Comments Filed under: SQL Server

• Shrinking All Database Files in SQL Server

  Here is another SQL script that I keep handy in my toolbox: Shrink All Database Files.sql . Unlike the script that I shared in my previous post that simply truncated all transaction logs to free up disk space, this script is suitable for running in a Read More... Posted Friday, May 30, 2008 7:50 AM by Jeremy Jameson | 3 Comments Filed under: MOSS 2007, SQL Server

• Truncating All Transaction Logs in SQL Server

  One of the SQL scripts that I keep handy in my toolbox is Truncate All Transaction Logs.sql . While I would never recommend running this script in a Production environment (PROD), I find it to be very helpful for periodically freeing up disk space in Read More... Posted Friday, May 30, 2008 7:32 AM by Jeremy Jameson | 3 Comments Filed under: SQL Server

• Copying a SQL Server Database to Another Environment

  A couple of weeks ago I was troubleshooting a performance problem with the variations feature in Microsoft Office SharePoint Server (MOSS) 2007 and I needed to copy the content database to another environment for further analysis and testing. An easy Read More... Posted Monday, October 29, 2007 7:03 AM by Jeremy Jameson | 0 Comments Filed under: MOSS 2007, SQL Server