Differences

This shows you the differences between two versions of the page.

--- windows:sqlserver [2015/01/09 15:33] – [install SQLEXPR_x64_ENU.exe(sql server)] admin
+++ windows:sqlserver [2022/10/29 16:15] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ====== SQL Server ======
 ===== Install  SQL server =====
-==== install SQLEXPR_x64_ENU.exe(sql server) ====
+==== install sql server 2012 with Manage studio tools ====
+Download and Install SQLEXPRWT_x64_ENU.exe(SQL management studio was integrated in this package)
   * Authentication: **mixed mode**(authenticate with windows authentication and sql server authentication)
   * Change Data directories:{{:windows:sqlserver-directory.png|}} => change **data root directory** to d:\data
@@ Line 7: / Line 8: @@
     * from {{:windows:sqlserver-network-disable.png|}}
     * to {{:windows:sqlserver-network-enable.png|}}
-  * Config port 1433(not dynamic port) for TCP/IP
+  *   * In SQL Server Configuration:  go to SQL Server Network Configuration→Protocols for MSSQLServer→TCP/IP, Config port 1433(not dynamic port) for TCP/IP{{:windows:sqlserver-ipconfig.png|}}
-{{:windows:sqlserver-ipconfig.png|}}
+==== install SQL server 2008  ====
-==== install SQLManagementStudio_x64_ENU.exe ====
+  - step1: SQLEXPR_x64_ENU.exe  2008
-to manage sql server(must install SQLEXPR_x64_ENU.exe before install this package)
+  - step2: install SQLManagementStudio_x64_ENU.exe
 ===== Basic Config with SQL Server Configuration Tool =====
 ==== Change config TCP/IP connection ====
@@ Line 25: / Line 26: @@
 </code>
   * Step2: Using SQL Server Configuration Tool, go to **SQL Server Network Configuration**->**Protocols for MSSQLServer**->**TCP/IP**{{:windows:sqlserver-ipconfig.png|}}
+==== view database config(data config, log config...) ====
+  * step1: select database as below image:
+{{:windows:database-config.png|}}
+  * step2: right-click the database and click **properties** to see the database settings as below image:
+{{:windows:database-setting.png|}}
 ==== reset password ====
+===== Backup and restore =====
+==== backup and restore bak file ====
+  * to restore: right click **databases** and select restore database
+  * to backup:  right click **database name** and select **tasks -> backup**
+==== backup and restore sql scripts ====
+  * backup: right click **database name** and select **tasks->generate scripts**
+==== attach database file(mdf file) ====
+===== debug in sql server =====
+==== query log in sql server ====
+  * to view query log in sql server, we use sql server profiler
+  * with sql server express, we use expressprofiler(because in this version, the sql server profiler not exists): https://expressprofiler.codeplex.com/
+==== The actual stored procedure line number from an error message ====
+Error line numbers may not match the number returned in the error always, this is because when **the SQL server executes a stored proc, it has its own compilation & execution methodology**, so the line numbers vary based on the execution order it takes
+==== Debug stored procedure with break point ====