Home » SQL Server (Page 15)
Category Archives: SQL Server
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
Always on\Database Mirroring Automatic Page Repair
A special thanks to Daniel Jones [daniel.jones.0543@gmail.com] for showing up interest and writing informative article for our blog (http://mssqlfun.com/). Always on\Database Mirroring Automatic Page Repair One of the most useful as well as hottest feature in SQL Server is mirroring of database. It is helpful for numerous of organizations that implements the successful as … Continue reading
How Row versioning impact tempDB ?
Scenario: DBA found that tempdDBdatabase usage is getting high and most of the size is consumed by row versioning. DBA raised the issue with application team running that query. Once Application team close the session, tempDB usage comes normal. Question: Application tea raise concern “How can a select statement on table consume huge amount of … Continue reading