server 2012 unleashed

Just started to install server2012, the drive has not been installed to think is the driver of the problem, later on the internet to find a bit to understand why, because the server does not turn on the Wireless LAN function, and sound card services, the following simple way to introduce the solution to you:Wireless network card resolution method:The first step, go to "Server Manager"--〉 "Add roles and feat

/M01/58/D9/wKiom1S-PWuBCtMuAAMixpsTisc371.jpg "style=" float: none; "title=" 2015-01-20_193058.png "alt=" Wkiom1s-pwubctmuaamixpstisc371.jpg "/>Click "Make this primary language" to load the Chinese650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/58/D9/wKiom1S-PXCw4kIAAAJsGWTI1nM760.jpg "style=" float: none; "title=" 2015-01-20_193108.png "alt=" Wkiom1s-pxcw4kiaaajsgwti1nm760.jpg "/>Log out650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/58/D6/wKioL1S-Pkigg-FDAAH_zmxA0mk178.j

truncation at run time.The active_transaction transaction is active (all recovery models). A long-running transaction may exist at the beginning of a log backup. In this case, another log backup may be required to free up space.After reading the status, my problem is this log_backup, the log is not backed up, that is, the beginning of the dead loop, because hard disk space is not enough, can not be backed up can not delete the log, it became a dead loopThere is always a solution, the principle

"style=" Float:none; "alt=" Wkiom1dr4jcxdtwvaaeful7yodq712.jpg-wh_50 "/>For example, click OK can be deleted, if the execution error, you can select the Figure 2, Close existing connecting.650) this.width=650; "Src=" Http://s2.51cto.com/wyfs02/M00/83/28/wKioL1dr4I6gSmSaAAIWU470Wu0872.jpg-wh_500x0-wm_3 -wmp_4-s_3679250279.jpg "style=" Float:none; "title=" 2016-06-22_091959.jpg "alt=" Wkiol1dr4i6gsmsaaaiwu470wu0872.jpg-wh_50 "/>You can also click Script to view the delete T-SQL that deleted the d

/wKioL1kYNQ_ieAa5AAENdXgXUDg593.jpg "style=" float : none; "title=" d31.jpg "alt=" Wkiol1kynq_ieaa5aaendxgxudg593.jpg "/>650) this.width=650; "src=" https://s1.51cto.com/wyfs02/M00/95/A8/wKiom1kYNRGx8wjzAAHh7Qv5sCU738.jpg "style=" float : none; "title=" d32.jpg "alt=" Wkiom1kynrgx8wjzaahh7qv5scu738.jpg "/>650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M02/95/A8/wKiom1kYNRPwlSpZAAGczkjkA2g379.jpg "style=" float : none; "title=" d33.jpg "alt=" Wkiom1kynrpwlspzaagczkjka2g379.jpg "/>650) th

/M01/95/A7/wKioL1kYJxqTt8lKAAHvzs5XFk4074.jpg "style=" float : none; "title=" dhcp25.jpg "alt=" Wkiol1kyjxqtt8lkaahvzs5xfk4074.jpg "/>650) this.width=650; "src=" https://s2.51cto.com/wyfs02/M02/95/A7/wKiom1kYJxyBttzRAAE6an9AuyM507.jpg "style=" float : none; "title=" dhcp26.jpg "alt=" Wkiom1kyjxybttzraae6an9auym507.jpg "/>650) this.width=650; "src=" https://s4.51cto.com/wyfs02/M02/95/A7/wKiom1kYJyHgrTOnAAG61DmAbHQ101.jpg "style=" float : none; "title=" dhcp27.jpg "alt=" Wkiom1kyjyhgrtonaag61dmabh

To rename a computer at a command prompt:> netdom renamecomputer old_servername/newname:new_servernameRestart your computerConfigure the Network1 Viewing the network adapter namenetsh interface IPv4 show interfaces2 Using a DHCP networknetsh interface ipv4 set address name= "Local Area Connection" Source=dhcpnetsh interface ipv4 set DNS name= "Local Area Connection" Source=dhcp3 Using static IPnetsh interface ipv4 set address name= "Local Area Connection" Source=static addr=192.168.10.100mask=25

questions:The settings in Administrative Tools >> Local Security Policy >> account Policies >> password policy are grayed out and the properties are non-editable.Reason:We are changing the local policy, at which point the computer is in the domain and is managed by the domain.Solution:The steps are as follows:1. Open the Group Policy Management interface: Administrative Tools >> Group Policy Management, if this feature is not found, you need to install it and add new features in Service Manager.

Cross-site testASP, PHP, and ASP. NET can be accessed normally.· D:\wwwroot\discuz is the path to another site that is fully independent, and we use him for cross-site testing.。ASP can not cross stationASP. NET can not cross stationPHP can not cross-siteIf you need to create additional sites, repeat steps 1, 2, 3, and 4.6. Other Safety InstructionsIndividual anonymous accounts for each site are only part of the solution to security-necessary operations, but there may also be cross-site intrusio

-content/uploads directory5. Testing the websiteWebsite access is normal, background upload pictures, files are normal.At this point, WordPress security settings have been completed, after Setup, although the hacker may also upload Trojan, but can not runHas greatly improved the site's security.If you can work with security aids again, the level of security can continue to improve.6. Safety Aid ToolsIt is recommended to use the "security package" developed by the Guardian God to prevent intrusio

is stored in this course) gives Apache_hws "read/write/delete", otherwise the websiteCannot be updated (if the site does not need to be updated, then just give "read" permission);4. Set PHP directory Permissions1) Set PHP installation directory permissions (in this case: "C:\PHP"): Administrators, SYSTEM "Full Control";Users "Read and execute";2) Set the PHP temp directory permission; temp directory location by php.ini"Session.save_path", "Upload_tmp_dir" two items specified.• As you can see, t

I do not know if you can remember a few days ago, there is a slightly scattered over the VMM to achieve the highest level of bare metal deployment of the post, in the video recording finished upload to Youku before, think about, there seems to be another thing did not do. That is, the server that needs to be managed has not enabled Remote Desktop Connection, and it is possible to implement remote management with Dell's Idrac through Out-of-band manage

Tags: sql Server; read-only; specific tablesCreate a read-only account and only read certain tables.Now let's share the steps of the operation.The premise of this operation is that the database is relatively large, there are many data tables, you need to select their own read-only data tables.The operation of the new account should not be unfamiliar, to everyone is not discussed.In the left User Mapping tab, set the database you want to specify and se

although the result of our previous query was orderly, the new table generated after the run was not sorted by Subprenum and the order was chaotic.It was discovered that this was due to the limitations of SQL Server itself and that if there was a special need to require the data in the staging table to be ordered, the problem could be solved by "creating a clustered Index". For details, please refer to the blog: https://www.cnblogs.com/kerrycode/p/51

']/value '). Value (' (value) [1] ', ' NVARCHAR (100) ')--get sql_textset @sql_text = @xmlData. Query ('//action[@name = ' Sql_text ']/ Value '). Value (' (value) [1] ', ' NVARCHAR (MAX) ')--start inserting data insert #MyData (database_id, Sql_text, username, client_hostname , Client_app_name, Cpu_time) VALUES (@database_id,--Database_id-int @sql_text,--Sql_text-nvarchar (max) @use Rname, @client_hostname, @client_app_name, @cpu_time) end TRY BEGIN catch END catch FETCH NEXT from Mycur into @

Label:Recently discovered Web sites are inaccessible because the database server disk has no more space left. The log file was found to be 70%, and shrinking the log file failed.The reason for the online lookup is that no backup cannot shrink the log file.A temporary solution:Back up the transaction log, and then shrink the log file. (You can also shrink a log file after a full database backup)A long-term solution:Make a maintenance plan, back up the

' filestream_access_level ', 2goreconfigure--start alter DATABASE test SET FileStream (non_transacted_ ACCESS = full, Directory_name = ' test ')--add FILESTREAM filegroup alter DATABASE test add FILEGROUP filestreamgroup CONTAINS filestr Eamgoalter DATABASE Test ADD FILE (NAME = ' fg1 ', FILENAME = ' D:\FileStream\fg1 ') to FILEGROUP filestreamgroupgo--requires non-transactional access, Directory_nameselect db_name (database_id), non_transacted_access, Non_transacted_access_desc, directory_name

information, see Considerations for switching from the full or bulk-logged recovery model. In SQL SERVER 2008, BACKUP log with truncate_only is no longer supported, and to shrink the database log, you first need to truncate the file by setting the database recovery mode to simple. The statements are as follows: --BACKUP log TestDB with no_log UseTestDB; GO --Truncate The log by changing the database recovery model to simple. ALTER DATABASETestDBS

Original: SQL Server 2012 exception Issue (ii)--performance issues caused by installation mediaProblem Description: Production environment A database is upgraded from SQL Server R2 to SQL Server 2012, while the hardware is replaced, but after the migration, the performance d

1. After installing the virtual machine, check the size of the C drive, and find that the C disk is now 59.9GB, such as:2. Using the Window+r key, the Run window appears, enter ' cmd '--' CD C:\Program Files (x86) \VMware\VMware Workstation ', enter the path.3. At the command prompt, enter "Vmware-vdiskmanager", without any parameters, press ENTER. You can see all the parameter descriptions for the command.4. For reference, perform a command similar to the following: Vmware-vdiskmanager-x 80GbTh