Prerequisites 1) Run upgrade adviser on the databases for the instance you want to upgrade. 2) If any issues are found, talk to your SME for fixing the same. 3)If issues are fixed proceed with the actual upgrade. -- Do check for the other dependencies...
Master Purpose - Core system database to manage the SQL Server instance. In SQL Server 2005, the Master database is the logical repository for the system objects residing in the sys schema. In SQL Server 2000 and previous editions of SQL Server, the Master...
Reading the SQL Server log files using TSQL This is a sample of the stored procedure for SQL Server 2005. You will see that when this gets called it calls an extended stored procedure xp_readerrorlog. CREATE PROC [sys].[sp_readerrorlog]( @p1 INT = 0,...
Backup Compression in SQL Server s Microsoft has introduced backup compression feature from SQL Server 2008. This feature is very useful to save the time, reduces device I/O and storage cost and it is also a good backupstrategy option. You can configure...
SQL DBA Interview Questions and Answers for Freshers 1. What are the different components in SQL Server? Database Engine, Analysis Services, Reporting Services, Integration Services, Master Data Services, Data Mining, PowerPivot, Replication etc. 2. Tell...
SQL Server Wait Types – Trace and Tune Database Performance Issues It is a big challenge for database administrators to trace performance issues, tune and maintain database server effectively. I receive many queries regarding database performance issues,...
Backup All System Databases If you want to backup all system databases master, model and msdb then use below SQL script. DECLARE @DB VARCHAR(20) DECLARE @BkpFName VARCHAR(100) DECLARE @BkpFDate VARCHAR(50) SELECT @BkpFDate = REPLACE(CONVERT(VARCHAR(50),...
Backup All User Databases If you want to backup only user databases and don’t want to include system databases then you can use below SQL script. DECLARE @DB VARCHAR(20) DECLARE @BkpFName VARCHAR(100) DECLARE @BkpFDate VARCHAR(50) SELECT @BkpFDate = REPLACE(CONVERT(VARCHAR(50),...
Backup All User and System Databases DECLARE @BkpFDate VARCHAR(50) SELECT @BkpFDate = REPLACE(CONVERT(VARCHAR(50), GETDATE(), 102),'.','') + REPLACE(CONVERT(VARCHAR(50), GETDATE(), 108),':','') DECLARE Cursor_DBs CURSOR FOR SELECT name FROM master.sys.DATABASES...
Activity Monitor in SQL Server 2012 Activity Monitor is an inbuilt monitoring tool which comes with SQL Server Management Studio. This monitoring tool provides real-time information about processes, resource waits, data file I/O and recent expensive queries...
