Search results for 'app:weblogs' matching tags 'SQL 2005' and 'sql 2000'

Moving MSDB to new location

Anonymous — Tue, 06 Mar 2012 06:00:00 GMT

In recent past we have a situation where in we required to move MSDB, Model and Master databases to new location, the reason being faulty drive. While moving system databases to new location we need to be extra cautious. Let’s see the process step-by-step.

Step 1: Let’s query sys view and note down the location for database files

SELECT
NAME,
PHYSICAL_NAME AS 'PhysicalFilePath',
STATE_DESC AS 'DB Status'
FROM SYS.MASTER_FILES

Step 2: Run alter database and specify new location for database

SELECT
ALTER DATABASE MSDB
MODIFY FILE
(
NAME = MSDBData,
FILENAME= 'C:\SQLDB\Demo\MSDBData.mdf'
)
GO
ALTER DATABASE MSDB
MODIFY FILE
(
NAME = MSDBLog,
FILENAME= 'C:\SQLDB\Demo\MSDBLog.mdf'
)
GO

Step 3: Stop SQL Server service

Step 4: Once SQL Server service is stopped move MSDB database to new location
Step 5: Now, start SQL Server service. This time it will use the new path that we have configured in Step 2.
Note: If you have enabled and configure Database Mail, please make sure it works after you moved MSDB to new location.

Tomorrow, I will post about how to relocate Master database.

-- Hemantgiri S. Goswami (http://www.sql-server-citation.com/)

[MS KBs] New KB Articles At Microsoft 23 Aug 2010 - Weekly Summary

Anonymous — Tue, 24 Aug 2010 05:00:00 GMT

.NET Framework 2.0 2255379 Error message when you run an ADO.NET Framework application to remotely perform read or write operations on FILESTREAM data on a SQL Server 2008 server Outlook 2003 2317686 Outlook 2007 Troubleshooting Methodology: Crashes SQL...(read more)

[MS KBs] New KB Articles At Microsoft 23 Jun 2010 - Weekly Summary

Anonymous — Thu, 24 Jun 2010 05:00:00 GMT

.NET Framework 2.0 220686 Microsoft Advisory Services Engagement Scenario - .Net Application Consuming High Memory 221234 Microsoft Advisory Services Engagement Scenario - .Net Application Performing Slow Outlook 2003 224204 The "Import...(read more)

[MS KBs] New KB Articles At Microsoft 19 May 2010 - Weekly Summary

Anonymous — Wed, 19 May 2010 05:00:00 GMT

Outlook 2003 981725 Description of the Office Outlook 2003 Junk E-mail Filter update: May 11, 2010 202836 Outlook crashes on Windows Server 2008 R2 Terminal Server when DEP is enabled Outlook 2007 981726 Description of the Office...(read more)

[MS KBs] New KB Articles At Microsoft 28 Apr 2009 - Weekly Summary

Anonymous — Tue, 28 Apr 2009 05:00:00 GMT

.NET Framework 2.0 970519 You receive a "The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect" exception when using NVarchar parameters with Sqlclient Internet Information Services 6.0 967853 FIX: IIS...(read more)

[MMS] 2009 Early Bird Registration Closes on April 3rd!

Anonymous — Wed, 18 Mar 2009 05:00:00 GMT

Make sure you get in before 3rd April to get your discount... Register by April 3 rd and save over $300! Reserve your place now at the premiere technical event of the year for IT Management Professionals. Register before April 3 rd 2009 and you’ll save...(read more)

[MS KBs] New KB Articles At Microsoft 17 Feb 2009 - Weekly Summary

Anonymous — Wed, 18 Feb 2009 06:00:00 GMT

Expression Web 967682 HTML template created in Expression Web is not seen within Expression Media Internet Explorer 6.0 960715 Microsoft Security Advisory: Update Rollup for ActiveX Kill Bits 967728 You cannot deploy favorites with URLs that contain the...(read more)

[SQL] KB 967576 - Microsoft SQL Server Database Engine Input/Output Requirements

Anonymous — Mon, 09 Feb 2009 06:00:00 GMT

SQL Server requires systems to support ‘ guaranteed delivery to stable media ’ as outlined under the Microsoft SQL Server Always-On Storage Solution Review program ( http://www.microsoft.com/sqlserver/2005/en/us/storage-solutions-review.aspx This requirement...(read more)

[SMS 2003]Link to SQL 2005 SP3 added to SMS 2003 SQL Page

Anonymous — Thu, 18 Dec 2008 06:00:00 GMT

Download link to SQL 2005 SP3 added to SQL page [18/12/08] Contributed By: Cliff Hobbs [MVP ConfigMgr/ SMS] I've added a link to SQL 2005 SP3 to the SQL Page......(read more)

[ConfigMgr] New FAQShop Article 12th Nov 08

Anonymous — Wed, 12 Nov 2008 06:00:00 GMT

Useful SQL Information [12/11/08] Contributed By: Cliff Hobbs [MVP ConfigMgr/ SMS] I've updated the SQL Page to not only include download locations for all of the SQL Service Packs but also to contain...(read more)