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...
SQL Server Database Migration Migrating a database is very critical and time bound process, if anything goes wrong then its very difficult to rollback things and move back to existing environment again. So its very important to prepare a checklist before...
HOW To modify a synchronization schedule for a pull subscription in Management Studio Connect to the Subscriber in Management Studio, and then expand the server node. Expand the SQL Server Agent folder, and then expand the Jobs folder. Right-click the...
HOW To modify a synchronization schedule for a push subscription in Management Studio Connect to the Distributor in Management Studio, and then expand the server node. Expand the SQL Server Agent folder, and then expand the Jobs folder. Right-click the...
