Microsoft SQL database file was changed the location from drive E to its default location drive C after the windows server update

Question

Hi All,

After the windows server update, the database file location (drive E) was moved to a default file location (drive C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\). Does anyone know why is this  happening?

thanks and regards

Manilyn

Answer 1

open SSMS ->connect to a Server->right click on the server ->Facets-> Check for BackupDirectory in the Server settings,

to check why it hapened so ,please check you SQL Server Error Log,

---

Ramesh Babu Vavilla MCTS,MSBI

Answer 2

You can use this:

EXEC  master.dbo.xp_instance_regread
 N'HKEY_LOCAL_MACHINE', N'Software\Microsoft\MSSQLServer\MSSQLServer',N'BackupDirectory'

to find your backup folder path.

As Babu mentioned, to see why it has happened just check SQL Server error log.

Cheers

---

MCP, MCTS, MCITP

Answer 3

[System.Reflection.Assembly]::LoadWithPartialName('Microsoft.SqlServer.SMO')  | out-null

$s = new-object ('Microsoft.SqlServer.Management.Smo.Server') 'InstanceName'
echo $s.Settings.DefaultFile
echo $s.Settings.DefaultLog
echo $s.Information.MasterDBPath
echo $s.Information.MasterDBLogPath

Please run the above & share the output.

---

yup

Answer 4

After the windows server update, the database file location (drive E) was moved to a default file location (drive C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\). Does anyone know why is this  happening?

>>Iam not sure that , you mean that the db files was in E drive before windows update & you mean after windows update the DB files moved to C:\......\ ?

I dont think so..that will happens

because usually in-case if you have used it create Database <dbname> without any parameter then it will uses the default Database settings on the SQL and if you need to point to other then you have to specify.... Manually.

---

Rama Udaya.K ramaudaya.blogspot.com ---------------------------------------- Please remember to mark the replies as answers if they help and un-mark them if they provide no help.