The Mystery Recently a folder within a SMB share on the Windows Server (network share) displayed only certain files but not others for a certain user. For an administrator, the share displayed all the files in the folder. Obviously, there is some difference in the permissions, but what? Examining the difference between the files (using … Continue reading PowerShell: Manipulating & Copying File Permissions In Windows
SQL Server: Detach/Attach Gotchas!
Please checkout my post on "Moving Datafiles" which is very related to this method but is preferred more. One would think that detaching and attaching databases is one of the simplest things to do. It is. However, there are so many things that can break by that simple operation by itself and nothing more. Recently, … Continue reading SQL Server: Detach/Attach Gotchas!
SQL Server: Move Database Files To Another Drive/Folder Like A Pro!
Last week, I wrote a post on how to relocate Oracle data files from one drive to another. Today, let us see how simple it is to do the same in SQL Server. I recently had to move 125 databases on an instance to a new and expanded volume mountpoint to allow for growth, which … Continue reading SQL Server: Move Database Files To Another Drive/Folder Like A Pro!