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
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.
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"
When SQL Analysis is installed, but there is no way to connect to it you probably installe only the basis management tools.
Rerun the installation and make sure the complete management tools are installed.
