Home » Articles posted by rohitmssqlfun (Page 8)
Author Archives: rohitmssqlfun
SSMS error – Unable to Connect to SSIS – The Specified Service Does Not Exist as an Installed Service
Issue: SQL Server Integration Service (SSIS) 2016 unable to connect from SQL Server Management Studio (SSMS) 17.0. Error: Connecting to the Integration Services service on the computer "<Server Name>" failed with the following error: "The specified service does not exist as an installed service.” This error can occur when you try to connect to a … Continue reading
How to Perform and schedule SSAS Backups ?
Steps to configure schedule SSAS Cube \ OLAP database backups :- 1. For each SQL Server Analysis Services Environment. In order to create recovery strategy, we need to have backups of the metadata that describes the databases. SQL Agent jobs must be created to run backups remotely. Typically, one of the SQL Server Engine that … Continue reading
What is DBCC CLONEDATABASE ?
DBCC CLONEDATABASE is new feature comes up with SQL Server 2014 Service Pack 2 and above. DBCC CLONEDATABASE is used to create read only copy of an existing database. Cloned database includes the schema and statistics of the source database but no data. · Source database should be online & readable while creating clone database. … Continue reading
Database snapshot could not be created and the database or table could not be locked
DBCC CheckDB failed with error “database snapshot could not be created and the database or table could not be locked” Error: The database could not be checked as a database snapshot could not be created and the database or table could not be locked. See Books Online for details of when this behavior is expected … Continue reading
Cumulative Update #2 for SQL Server 2016 SP1
The 2nd cumulative update release for SQL Server 2016 SP1 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing model, please visit: CU#2 KB Article: https://support.microsoft.com/en-us/help/4013106 Understanding Incremental Servicing Model for SQL Server Microsoft® SQL Server® 2016 SP1 Latest Cumulative Update: https://www.microsoft.com/en-us/download/details.aspx?id=54613 … Continue reading