Check FSMO Roles

Run the following vbs script to show you the location off the FSMO roles:

 

Set objRootDSE = GetObject("LDAP://rootDSE")

Set objSchema = GetObject _
    ("LDAP://" & objRootDSE.Get("schemaNamingContext"))
strSchemaMaster = objSchema.Get("fSMORoleOwner")
Set objNtds = GetObject("LDAP://" & strSchemaMaster)
Set objComputer = GetObject(objNtds.Parent)
WScript.Echo "Forest-wide Schema Master FSMO: " & objComputer.Name

Set objNtds = Nothing
Set objComputer = Nothing

Set objPartitions = GetObject("LDAP://CN=Partitions," & _
    objRootDSE.Get("configurationNamingContext"))
strDomainNamingMaster = objPartitions.Get("fSMORoleOwner")
Set objNtds = GetObject("LDAP://" & strDomainNamingMaster)
Set objComputer = GetObject(objNtds.Parent)
WScript.Echo "Forest-wide Domain Naming Master FSMO: " & objComputer.Name

Set objDomain = GetObject _
    ("LDAP://" & objRootDSE.Get("defaultNamingContext"))
strPdcEmulator = objDomain.Get("fSMORoleOwner")
Set objNtds = GetObject("LDAP://" & strPdcEmulator)
Set objComputer = GetObject(objNtds.Parent)
WScript.Echo "Domain's PDC Emulator FSMO: " & objComputer.Name

Set objRidManager = GetObject("LDAP://CN=RID Manager$,CN=System," & _
    objRootDSE.Get("defaultNamingContext"))
strRidMaster = objRidManager.Get("fSMORoleOwner")
Set objNtds = GetObject("LDAP://" & strRidMaster)
Set objComputer = GetObject(objNtds.Parent)
WScript.Echo "Domain's RID Master FSMO: " & objComputer.Name

Set objInfrastructure = GetObject("LDAP://CN=Infrastructure," & _
    objRootDSE.Get("defaultNamingContext"))
strInfrastructureMaster = objInfrastructure.Get("fSMORoleOwner")
Set objNtds = GetObject("LDAP://" & strInfrastructureMaster)
Set objComputer = GetObject(objNtds.Parent)
WScript.Echo "Domain's Infrastructure Master FSMO: " & objComputer.Name

 

download link: [wpdm_file id=49]

WMIC Delete shadowcopy

1) Open an elevated command prompt (“cmd” + ctl-shift-enter)

2) At the command prompt, type “wmic”, after some time “wmic:root\cli>” will appear

3) Type “shadowcopy”

4) it will display a list of existing shadow copies

4) Type “shadowcopy delete”

5) one by one, it will give a “Y/N” style prompt, confirming the deletion of each individual shadow copy.

6) Type “exit” to get back to normal command prompt

Changing the default SQL Server backup folder

When installing SQL, you can change the default SQL Server backup folder. When you want to change this afterwards you can’t do this through a gui.

 

If you want to change the path open REGEDIT and navigat to the following key (or similar for your instance or SQL version:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.50.MSSQLSERVER\MSSQLServer

Change the BackupDirectory key to the desired path.

This default path will be used when backing up a database.

TSM add/remove schedule as a service

Install the windows Service:

dsmcutil install sched /name:"TSM Client Scheduler %NODENAME%" /node:%NODENAME% /password:%PASSWORD% /autostart:no /startnow:no /clientdir:"%DSM_DIR%" /optfile:"%OPTFILE%"

 

Remove the windows service:

 dsmcutil remove /name:"TSM Central Scheduler Service"

source: http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp?topic=%2Fcom.ibm.itsmfdt.doc%2Fans60000559.htm

TDP for backups fail with rc = 612

The TDP for backups fail with the following error:

ACN5705W An error was encountered with Tivoli Storage Manager API initialization, rc = 612.

The TSM API’s message file dscenu.txt may have become corrupted, or is at the wrong version. Check dscenu.txt in program files\tivoli\tsm\baclient against the dscenu.txt file in program files\tivoli\tsm\api – if the versions and last-modified dates do not match, then this technote probably applies.

Make a copy of dscenu.txt from the baclient directory to the API directory, and test again.