• Product Review: Stellar Phoenix SQL Database Repair

    Product Review: Stellar Phoenix SQL Database Repair

    Introduction Business-critical data should be safe and always available without downtime or interruption. In that case, working as an MS SQL Database Administrator (DBA) is not easy as it involves keeping the SQL Server database up and running 24*7*365. If database entries do not happen correctly these lead to...
  • An error occurred when attaching the database(s). Click the hyperlink in the Message column for details

    An error occurred when attaching the database(s). Click the hyperlink in the Message column for details

    An error occurred when attaching the database(s). Click the hyperlink in the Message column for details. While attaching .mdf and .ldf database files in SQL server management studio, it throws error attached image – 1 Image – 1 It seems permission issue for which it gives this error while...
  • How to Restore Database using SQL Management Studio

    How to Restore Database using SQL Management Studio. I will explain in details with screenshot for better understanding. You need Server name, Authentication, Login and Password. As in my case I have filled the required credential to log in to my local Database Server. Once after you login successfully....
  • SQL Backup

    How to Backup a Database using SQL Management Studio

    How to Backup a Database using SQL Management Studio I will do it in steps with screenshots for better understanding. First we need to connect to the Database Server from where we need to take backup of database. STEP – 1 You need Server name, Authentication, Login and Password....
  • How to truncate a SQL Server Data file

    How to truncate a SQL Server Data file. While working with SQL Server, for some reason your database log file (.ldf file) keeps increasing in size. to reduce the size of the log file … I just followed the below mentioned steps. Open Microsoft SQL Server Management Studio Select...
  • User Group or Role already exists in the current database

    User, Group, or Role already exists in the current database. (Microsoft SQL Server, Error: 15023) While after restoring the database I just created the users in the new server and then trying to map to the restored databases …. I got an error like User, Group, or Role already...
  • Create a rule in Windows Firewall to give access to connect Microsoft SQL Server

    Create a rule in Windows Firewall to give access to connect Microsoft SQL Server On the Start menu, click Run, type WF.msc, and then click OK. In the Windows Firewall with Advanced Security, in the left pane, right-click Inbound Rules, and then click New Rule in the action pane. In the Rule Type dialog box, select Port, and then click Next....
  • Enable and change FILESTREAM Setting SQL Server 2008 R2 Express

    When you are trying to restore one database and you stuck with the error showing FileSTREAM feature is disabled.   Solution To enable and change FILESTREAM settings     On the Start menu, point to All Programs, point to Microsoft SQL Server 2008 R2, point to Configuration Tools, and then...
  • Connect to the SQL Server 2008 Express remotely

    Steps to configure Open SQL Server Configuration Manager. Click Start -> Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager. On SQL Server Configuration Manager, select SQL Server Services on the left window. If the state on SQL Server Browser is not running, you...