Archives: July 2012
Analysis Services databases should be backed up at regular intervals like any other database. Here are the basics.
Using the GUI: Connect to the SSAS service in SQL Server management studio. Right click on the database and select backup.
The Backup dialog presents a number of options.
Allow file overwrite… Read more
SQL Server stores its authentication mode in the registry. The registry can be read and updated using the T-SQL commands xp_regread and xp_regwrite.
Step 1: Construct our registry key path, run the following query and record the result:
DECLARE @InstanceName NVARCHAR(1000), EXEC master..xp_regread N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\Microsoft SQL Server\Instance Names\SQL\', N'MSSQLSERVER', --for…