-->
SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Ganapathi's MSSQLLover

Ganapathi Varma is an MCP Lead Database Administrator and Blogger. He works as Lead SQL Server DBA for CtrlS Datacenters pvt ltd, Asia's only Tier 4 datacenter. He is responsible for managing thousands of SQL instances providing database managed services, High Availability and Disaster Recovery. Other than SQL Server, he is also expertised in different datacenter technologies. He is the owner of MSSQLLover blog and he is fully dedicated to the SQL Server community. You can also visit the mssqllover fb page for more SQL blogs and follow FB group: SQLHyderabad.

Archives: January 2018

How to Change the File Extension for a Data File


Link Below:

How to Change the File Extension for a Data File


In general, the file extensions for our SQL Data Files are .mdf, .ndf and .ldf.
But, a different file extension also work with SQL Server.

This article helps in finding a way to rename the file extensions.

Read more

0 comments, 289 reads

Posted in Ganapathi's MSSQLLover on 11 January 2018

Changing the Path for the Master Database


Link Below:


Changing the Path for the Master Database

This article will show how we can move the master database to a new location.
The ALTER DATABASE command would work for moving all the user databases and some system databases, including model, msdb and tempdb, but changing the path of…

Read more

0 comments, 267 reads

Posted in Ganapathi's MSSQLLover on 11 January 2018