This blog is about another common error reported by many DBA to me. He faced error related to create file in OS.
Here is the text of the message.
Rename MDF File Extension in SQL Server, Step by Step
To rename MDF file extension values safely, take the database offline, tell SQL Server the new file name, rename the file on disk, and bring the database online. This post walks through the four steps on a demo database. It also explains the RECOVERY_PENDING state you see when the two names don’t match.
SQL SERVER- Error: 18204, Severity: 16 – Backup Failure – Operating System Error 1240 (The Account is not Authorized to Log in From This Station)
A client’s backups to a file share failed at random with error 18204 and OS error 1240. The error message pointed to the real cause of this Backup Failure.
SQL SERVER – SQL Server: Getting OS information using DMV
Need the Windows version SQL Server runs on? Get OS information with the sys.dm_os_windows_info DMV, or read it from the ERRORLOG at startup.
Physical and Virtual Memory Explained for SQL Server DBAs
Physical and virtual memory are two different things, and SQL Server reports on both. This post explains RAM, address space, the page file and paging in plain words. It then reads each number with three read-only queries and ends with settings worth checking.
Recovering Unsaved Query Windows After SSMS Closes Unexpectedly
A restart ate your script, but maybe not all of it. Two places to look: SSMS recovery files and the text SQL Server remembers.
Find mysqld.exe on Windows and Fix ‘mysql’ Is Not Recognized
To find mysqld.exe on Windows, search the drive with dir or where, or ask the running server where it lives. This post fixes the ‘mysql’ is not recognized error by adding the bin folder to PATH, and it shows every command with its real output.