Profile cover photo
Profile photo
Saurabh Sinha
275 followers -
Project Manager
Project Manager

275 followers
About
Saurabh's posts

Post has attachment

Post has attachment

Post has attachment
How to find Publisher , Publisher server and Publisher databases in SQL Server Replication
--******** Execute at the Publisher in the master database ********-- --Which databases are published for replication and what type of replication? EXEC sp_helpreplicationdboption; --Which databases are published using snapshot replication or transnatio...

Post has attachment
How to find Distributor , Distributor server and Distributor databases in SQL Server Replication
--******** Execute at the Distributor in the master database ********--

USE master;
go --Is the current server a Distributor?
--Is the distribution database installed?
--Are there other Publishers using this Distributor? EXEC sp_get_distributor --Is th...

Post has attachment
Script To Retrieve SQL Server Database Backup History
To retrieve backup history from sql server instance we have to query 3 tables  msdb.dbo.backupset : This Provides information concerning the most-granular details of the backup process msdb.dbo.backupmediafamily : This Provides metadata for the physical bac...

Post has attachment

Post has attachment

Post has attachment
SQL Server Installation Add Features is not Showing All Instances
Today we get a request to install SQL server reporting services for 4 of 8 of the instances on a server. As usual we pick our sql 2012 dump and start installing. When we reached to Add feature page of installation we were not able to see 4 of 8 instances in...

Post has attachment
How To Find Windows Version Using Registry and SQL Query
We have to run this query from sql server , by connecting each server via query analyzer only You can also club below query  with given powershell link " Power Shell Script To Read Registry "  Note : To find other server details please refer : How To Find S...

Post has attachment
How To Extract \ Read Tables from Backup File In SQL Server Without Restoring Database
Today we face a issue where user want some table and procedures from a 2 TB database which we have already deleted and only have old backup. User want to us to restore database on server where over all free space was only 1 TB.  To save us from this mess on...
Wait while more posts are being loaded