Wish you & your family very happy & prosperous new year 2013.
Happy New Year – 2013
1 Reply
Category Archives: Notes
Steps to Move SQL Server Log Shipping Secondary Database Files
Problem
With SQL Server is it possible to move the secondary database involved with Log Shipping to a different drive without disturbing the Log Shipping configuration? If so, what are the steps to accomplish this task? Check out this tip to learn more.
sys.dm_server_services
sys.dm_server_services DMV is available in SQL Server 2008 R2 SP1 and SQL Server 2012. It will return the information about the below SQL Services on the current instance.
- SQL Server (2008 R2 SP1 and SQL Server 2012)
- SQL Server Agent services(2008 R2 SP1 and SQL Server 2012)
- Full-Text(SQL Server 2012)
Powershell Script to get the Operating System Infomrmation
You can use the Win32_OperatingSystem class to get the Operating system info.
$hostname = "Enter Computer Name" Get-WmiObject -class win32_operatingsystem -computer $hostname | select-object *
Link to download Sample SQL Server Databsae
Click Me to download sample database
aiDeeva.com 