Getting Basic Info via PowerShell

Question

Hey gang,

Anyone have a snippet to retrieve the default backup and data folders using PowerShell?

Thanks!

Answer 1

0

See if this helps. You can paste this into Powereshell ISE and run.

[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | out-null
[System.reflection.assembly]::LoadWithPartialName('Microsoft.SqlServer.SMOExtended') | out-null
$instance = gc env:computername #get the computername
$s = new-object ("Microsoft.SqlServer.Management.Smo.Server") $instance
$settings = $s.Settings
$bkdir = $s.Settings.BackupDirectory #gets the backup directory 
$datafldr = $s.Settings.DefaultFile #gets the data directory 
$Logflder = $s.Settings.DefaultLog #gets the log directory 

$bkdir
$datafldr
$Logflder

answered May 01 '11 at 09:07 AM

sqlaj 1
1.3k ● 2

Weird... it appears that Settings.DefaultFile and Settings.DefaultLog aren't "populated" until you actually set them to something. Can someone else try the code on a fresh install and see if they get the same experience of blank results?

May 02 '11 at 06:42 AM Blackhawk-17

(comments are locked)

Answer 2

0

yup ... http://www.mssqltips.com/tip.asp?tip=1985

answered Apr 29 '11 at 08:34 AM

Fatherjack ♦♦
38.8k ● 56 ● 73 ● 104

Getting the backup folder returned no problem... The data and log entries are coming back empty.

Apr 30 '11 at 10:01 PM Blackhawk-17

(comments are locked)

Answer 3

0

We have drive and configuration standards for all SQL installs. By default SQL uses the install directory.

Do you have databases on the server? Can you create a database within SSMS? Where does it put the data and log files?

Here is a link to MSDN about default installation, may be of some help. http://msdn.microsoft.com/en-us/library/ms143547.aspx

answered May 02 '11 at 08:42 AM

sqlaj 1
1.3k ● 2

I support many different Clients and, between various standards and legacy installs, I can not be assured that the default will be the correct location. Often the data files are on one SAN LUN under a Data directory and the log files are on a different LUN under Logs.

May 02 '11 at 10:15 AM Blackhawk-17

(comments are locked)

Getting Basic Info via PowerShell

Follow this question

Related Questions