Monthly Archives: January 2015
How to find the filesystem location of an MS-SQL database
Open SQL management studio Login with a valid username and password Expand “Databases” Right-click on the database in question and choose “Properties” In the left navigation pane, choose “Files” On the right details pane, scroll horizontally until you see “Path” … Continue reading
Posted in Microsoft SQL Server
Leave a comment
Configuring retention policies
Retention policies allow the storage and retrieval of previous versions of backup data. This is an important feature as it allows an easy method of complying with business data retention laws or guidelines. A convenient feature of retention policies is … Continue reading
Error: SQL Server does not exist or access denied. ConnectionOpen (Connect())
Error [Microsoft][ODBC SQL Server Driver][DBMSLPCN]SQL Server does not exist or access denied. [Microsoft][ODBC SQL Server Driver][DBMSLPCN]ConnectionOpen (Connect()). Cause TBD Resolution TBD
Posted in MS-SQL Errors
Leave a comment