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

Posted in File backup: Desktop: issues with backup | Tagged , | Leave a comment

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