Sign in
Microsoft.com
 
System Center Configuration Manager TechCenter
 
 
 
System Center Configuration Manager TechCenter > System Center Configuration Manager Forums > Configuration Manager Backup and Recovery > Changing SQL Backup configuration after moving site database files
Ask a questionAsk a question
Search Forums:
 

QuestionChanging SQL Backup configuration after moving site database files

  • Friday, September 18, 2009 8:33 PMTechLee Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hi there,

    I am using SCCM 2007 SP1.  I have moved my database files which were on the system partition of my remote database server to another partition on the same remote database server using the detach, move files then attach method.  My question is the the SMS_SITE_BACKUP task is still looking to the default location for the database files and obviously they are no longer there.

    here is the log line showing that it is looking in the wrong place:

    Site SQL Dir = \\SCCMDB1\C$\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\.

    Anyone know where abouts I can change this so it now points to the D: drive on that same server?

    Thanks in advance
     

All Replies

  • Sunday, September 20, 2009 9:55 AMJannes AlinkMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    1
    Sign In to Vote
    Hi,

    Take a look at the following article:
    http://technet.microsoft.com/en-us/library/bb680707.aspx
    Please mark posts as Answered if appropriate.
    • Unmarked As Answer byTechLee Tuesday, September 22, 2009 12:49 PM
    • Marked As Answer byTechLee Monday, September 21, 2009 12:58 PM
    •  
     
  • Monday, September 21, 2009 12:58 PMTechLee Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hi Jannes,

    Thanks I had read that article, I was just hoping to be able to do a quick config file or regedit rather then running the setup.  I dont know why it just makes me nervous running the setup described in the article.  Thanks for your help much appreciated.
     
  • Tuesday, September 22, 2009 12:53 PMTechLee Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Hi Jannes,

    That didnt seem to work it still is not backing up the .mdf and ldf files.

    All others items are backing up fine.  The site SQL directory still points to the same location in the log

    Site SQL Dir = \\SCCMDB1\C$\PROGRAM FILES\MICROSOFT SQL SERVER\MSSQL.1\MSSQL\.


    Any other ideas?

    Thanks in advance
     
  • Tuesday, September 22, 2009 3:49 PMTechLee Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Sign In to Vote
    0
    Sign In to Vote
    Sorry it looks like I was looking in the wrong place, the Site SQL Dir is correct and is unrelated to my problem it appears

    After running the setup again and modifying the sql configuration as described by Microsoft, I still had the same issue.

    It took a couple of registry changes to correct the issue.

    On the Primary Site Server I edited the following keys/values:

    HKLM\Software\Microsoft\SMS\SQL Server

    I changed the following values as they contained the wrong names and paths:

    Device Name
    Device Path
    Log Device Name
    Log Device Path

    The paths pointed to the original locations of the mdf and ldf files on the C: drive of the remote database server.  The original paths were:

    C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SMSData_SJ1.mdf
    C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\SMSLog_SJ1.ldf

    which I changed to the path on the remote DB Server:

    D:\MSSQL\90\Data\SMS_SJ1.mdf
    D:\MSSQL\90\Data\SMS_SJ1_log.ldf

    I also changed the device names to that of what the paths ended in.  I dont know where these values came from because at no point did I change the device names of the database files when I did the detach, move, then attach.