Database: mssql
Queries to take table backup:
select * into xxx_price_bkp_20160602 from xxx_price
Make sure to check number of records:
select count(1) from xxx_price_bkp_20160602
To verify locks/long running process on DB
sp_who2
Query to verify full index enabled on DB
SELECT
CASE
WHEN
FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1
THEN
'INSTALLED'
ELSE
'NOT INSTALLED'
END IsFullTextInstalled
Queries to take table backup:
select * into xxx_price_bkp_20160602 from xxx_price
Make sure to check number of records:
select count(1) from xxx_price_bkp_20160602
To verify locks/long running process on DB
sp_who2
Query to verify full index enabled on DB
SELECT
CASE
WHEN
FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1
THEN
'INSTALLED'
ELSE
'NOT INSTALLED'
END IsFullTextInstalled
Comments
Post a Comment