SQLServer2005 百炼成钢
1、ISO文件解压到硬盘安装，CD目录必须是server和tool，否则安装无法成功。 2、索引提高性能仅企业版有效 3、针对IBM X3850 X5或HP DL580 G7等采用最新XEON E7的六核CPU，SQLServer2005企业版必须首先MSCONFIG中奖NUMPROC设置为1或2，重启机器，安装SQLServe
1、ISO文件解压到硬盘安装，CD目录必须是server和tool，否则安装无法成功。
2、索引提高性能仅企业版有效
3、针对IBM X3850 X5或HP DL580 G7等采用最新XEON E7的六核CPU，SQLServer2005企业版必须首先MSCONFIG中奖NUMPROC设置为1或2，重启机器，安装SQLServer，下载SP3以上补丁，然后取消NUMPROC，重启机器，否则无法成功使用6核
4、由于许多SQL应用基于了共享文件的前端调用，要求在组策略中选择启用经典模式，并打上安全补丁：WindowsServer2003.WindowsXP-KB958644-x64-CHS
5、如果系统为Windows 2003 X64/X32,将网卡的高级特性TOE和RSS禁用。然后打上系统补丁：WindowsServer2003.WindowsXP-KB948496-x64-CHS，MicrosoftFixit50051，然后重启机器
6、实例安装请使用安装程序进行配置并安装。
7、当遇到SQL服务无法启动的时候，可以检查data下的库文件是否被压缩了，取消压缩
8、可以修复master系统数据库，采用start /wait setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=123 和 setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=123
sqlservr.exe -c -m
在SQLCMD下，Restore database master from disk=’ C:/Program Files/Microsoft SQL Server/MSSQL.1/MSSQL/Backup/master.bak
9、在SQLcluster下打补丁需在当前资源owner下
10、SQLcluster名字作为虚拟服务器名称，对应的群集资源名，对应的IP为群集IP,该IP和真实cluster1和cluster2在同一个public网段。需要配置应用外围配置，远程选择sqlcluter或者10.1.1.15，远程方式选择TCP和NAMES
11、SQL Studio 2008 R2无法正常显示2005的摘要以及报表
12、AD宕机会导致MSCS无效，最终导致即使SQL服务正常，但是使用SQLCLuster\test连接失败
13、MSCS资源的切换不影响SQL群集
14、可以建立多个datafile资源，每个实例使用一个datafile空间
15、SQL Server 命名实例的重命名计算机
sp_dropserver GO sp_addserver , local GO
17、当遇到安装过程中报错，COM+目录要求，说明DTC服务没有正确启动，设置登录NTServices密码为空，然后DOS下执行MSDTC -UNINSTALL和MSDTC -INSTALL
18、共享磁盘资源的顺序很重要，下图是配置集群的时候所注意的顺序
19、当磁盘发生无法读写的 时候，未必是磁盘的问题，更多的可能性是群集问题，群集使用磁盘的原则是每次只有1个节点使用磁盘，所以启动cluster service后可以对磁盘进行读写。
20、当SQLcluster出现 node1和2都对磁盘进行了误操作后，建议删除DNS记录，关掉1，在2上进行本机登录，初始仲裁盘和数据盘。
AUTOMOUNT
AUTOMOUNT ENABLE
AUTOMOUNT DISABLE
DISKPART>
21、多路径问题，当出现类似天佑的问题的话，重装PowerPath 5.5 SP1 64bit即可
22、群集新建失效，由于原来有已经被破坏的群集和节点失败，所以，需要以下步骤
cluster node /forcecleanup
regedit Localmachine/cluster 删除
F3在注册表中寻找cluster全字匹配，找到以前的历史记录，删除注册表内容
重新启动计算机
23、每个lun对应一个磁盘，MSCS不对磁盘号负责，对分区盘符和卷标负责，而RoseHA对ID负责。
24、当仲裁盘导致群集服务启动失败的话，可以在服务启动参数中 -ResetQuotumLogging 或者NOQuotumLog
25、对于SQLServer2000至2008R2版本来说，目前最新的JDBC驱动是sqljdbc_4.0.2206.100_chs，这里4.0是版本，chs是中文，注意了，由于字符集的问题，建议应用是英文就选择驱动是英文，应用是中文则驱动是中文，另外内含2个JAR，一个有sqljdbc4,一个没有4，这里的4是指type 4驱动，建议JDK1.4环境以上使用带4的JAR，老环境可以使用不带4的版本。
26、我们连接并测试SQLServer2008的JAVA程序如下：这个程序我单独写了一个帖子：点击打开链接
27、如果现有的SQL群集，出现了网卡硬件故障，你需要更换网卡，怎么办？ 首先，关机节点1，等资源切换到节点2后，安装节点1的网卡，配置和安装网卡驱动，配置然后配置IP地址，并禁用原来的PUBLIC网卡，将新网卡配置为和原网卡IP一致，然后重启操作系统。再将资源切换到节点1，然后再节点2上配置相同的操作，最后启动集群资源即可。启用原来的故障网卡后禁用。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
How to recover expired WeChat files? Can expired WeChat files be recovered?
Feb 22, 2024 pm 02:46 PM
Open WeChat, select Settings in Me, select General and then select Storage Space, select Management in Storage Space, select the conversation in which you want to restore files and select the exclamation mark icon. Tutorial Applicable Model: iPhone13 System: iOS15.3 Version: WeChat 8.0.24 Analysis 1 First open WeChat and click the Settings option on the My page. 2 Then find and click General Options on the settings page. 3Then click Storage Space on the general page. 4 Next, click Manage on the storage space page. 5Finally, select the conversation in which you want to recover files and click the exclamation mark icon on the right. Supplement: WeChat files generally expire in a few days. If the file received by WeChat has not been clicked, the WeChat system will clear it after 72 hours. If the WeChat file has been viewed,
Photos cannot open this file because the format is not supported or the file is corrupted
Feb 22, 2024 am 09:49 AM
In Windows, the Photos app is a convenient way to view and manage photos and videos. Through this application, users can easily access their multimedia files without installing additional software. However, sometimes users may encounter some problems, such as encountering a "This file cannot be opened because the format is not supported" error message when using the Photos app, or file corruption when trying to open photos or videos. This situation can be confusing and inconvenient for users, requiring some investigation and fixes to resolve the issues. Users see the following error when they try to open photos or videos on the Photos app. Sorry, Photos cannot open this file because the format is not currently supported, or the file
Can Tmp format files be deleted?
Feb 24, 2024 pm 04:33 PM
Tmp format files are a temporary file format usually generated by a computer system or program during execution. The purpose of these files is to store temporary data to help the program run properly or improve performance. Once the program execution is completed or the computer is restarted, these tmp files are often no longer necessary. Therefore, for Tmp format files, they are essentially deletable. Moreover, deleting these tmp files can free up hard disk space and ensure the normal operation of the computer. However, before deleting Tmp format files, we need to
How to transfer files from Quark Cloud Disk to Baidu Cloud Disk?
Mar 14, 2024 pm 02:07 PM
Quark Netdisk and Baidu Netdisk are currently the most commonly used Netdisk software for storing files. If you want to save the files in Quark Netdisk to Baidu Netdisk, how do you do it? In this issue, the editor has compiled the tutorial steps for transferring files from Quark Network Disk computer to Baidu Network Disk. Let’s take a look at how to operate it. How to save Quark network disk files to Baidu network disk? To transfer files from Quark Network Disk to Baidu Network Disk, you first need to download the required files from Quark Network Disk, then select the target folder in the Baidu Network Disk client and open it. Then, drag and drop the files downloaded from Quark Cloud Disk into the folder opened by the Baidu Cloud Disk client, or use the upload function to add the files to Baidu Cloud Disk. Make sure to check whether the file was successfully transferred in Baidu Cloud Disk after the upload is completed. That's it
What to do if the 0x80004005 error code appears. The editor will teach you how to solve the 0x80004005 error code.
Mar 21, 2024 pm 09:17 PM
When deleting or decompressing a folder on your computer, sometimes a prompt dialog box "Error 0x80004005: Unspecified Error" will pop up. How should you solve this situation? There are actually many reasons why the error code 0x80004005 is prompted, but most of them are caused by viruses. We can re-register the dll to solve the problem. Below, the editor will explain to you the experience of handling the 0x80004005 error code. Some users are prompted with error code 0X80004005 when using their computers. The 0x80004005 error is mainly caused by the computer not correctly registering certain dynamic link library files, or by a firewall that does not allow HTTPS connections between the computer and the Internet. So how about
What is hiberfil.sys file? Can hiberfil.sys be deleted?
Mar 15, 2024 am 09:49 AM
Recently, many netizens have asked the editor, what is the file hiberfil.sys? Can hiberfil.sys take up a lot of C drive space and be deleted? The editor can tell you that the hiberfil.sys file can be deleted. Let’s take a look at the details below. hiberfil.sys is a hidden file in the Windows system and also a system hibernation file. It is usually stored in the root directory of the C drive, and its size is equivalent to the size of the system's installed memory. This file is used when the computer is hibernated and contains the memory data of the current system so that it can be quickly restored to the previous state during recovery. Since its size is equal to the memory capacity, it may take up a larger amount of hard drive space. hiber
What should I do if I can't find the decompression option when I right-click on the rar file?
Mar 13, 2024 pm 07:07 PM
How to decompress rar files downloaded from the Internet? Under normal circumstances, you can just right-click and select Extract. However, some users right-click and find that they cannot find the decompression option. What is going on? In fact, it is caused by everyone not making relevant settings for the winrar software. You just need to make settings. The specific steps are as follows: 1. First, we open "winrar" on the computer. 2. Select "Options" in the toolbar and click "Settings". 3. Then select the "Integration" option above, and click "Context Menu Item" after entering. 4. At this time
Different uses of slashes and backslashes in file paths
Feb 26, 2024 pm 04:36 PM
A file path is a string used by the operating system to identify and locate a file or folder. In file paths, there are two common symbols separating paths, namely forward slash (/) and backslash (). These two symbols have different uses and meanings in different operating systems. The forward slash (/) is a commonly used path separator in Unix and Linux systems. On these systems, file paths start from the root directory (/) and are separated by forward slashes between each directory. For example, the path /home/user/Docume
