SysAdmin

How to shrink transaction log on mirror database (Microsoft SQL Server).

Solution: Applied to: Microsoft SQL Server 2008 R2 (but it’s similar for the other). To shrink transaction log manually on mirror database (Microsoft SQL Server) you have to follow these steps: Verify mirroring database: database must be in Principal, Synchronized state. Execute query: USE Databasename BACKUP LOG Databasename TO DISK = N’D:\Backup\DatabaseName_log.bak’ GO DBCC SHRINKFILE(‘DatabaseLogicalName_Log’, 1) …

How to shrink transaction log on mirror database (Microsoft SQL Server).Leggi altro »

Bring online database (access denied) Microsoft SQL Server 2012 BI – Accesso negato mettendo online un database

Problem: If you try to bring online a database and you receive “access denied” probably it’s possible, if you are an administrator with grant rights, that .mdf file doesn’t have right permissions. In my case the problem was NT Service/MSSQLSERVER or NT Service/MSSQLSERVER$IstanceName Solution: right click on .mdf file –> Properties –> Security — Edit –> …

Bring online database (access denied) Microsoft SQL Server 2012 BI – Accesso negato mettendo online un databaseLeggi altro »

How to activate Nessus on Backtrack 5 – Come attivare Nessus su Backtrack 5 ?

Solution: You have to register on http://www.nessus.org/register root@bt:~# /opt/nessus/bin/nessus-fetch –register code-that-you-receive-through-email Your activation code has been registered properly – thank you. Now fetching the newest plugin set from plugins.nessus.org… Your Nessus installation is now up-to-date. If auto_update is set to ‘yes’ in nessusd.conf, Nessus will update the plugins by itself. root@bt:~# nessus-update-plugins Fetching the newest …

How to activate Nessus on Backtrack 5 – Come attivare Nessus su Backtrack 5 ?Leggi altro »

Backtrack not possible to upgrade | dpkg: error processing se-toolkit (–configure): subprocess installed post-installation script returned error exit status 1

Problem: When you try to install, upgrade o autoremove packages with apt-get you can encounter in the following error: Setting up se-toolkit (4.2.1-bt0) … svn: OPTIONS of ‘http://svn.trustedsec.com/social_engineering_toolkit’: Could not read status line: Connection reset by peer (http://svn.trustedsec.com) dpkg: error processing se-toolkit (–configure): subprocess installed post-installation script returned error exit status 1 Errors were encountered …

Backtrack not possible to upgrade | dpkg: error processing se-toolkit (–configure): subprocess installed post-installation script returned error exit status 1Leggi altro »

How to redirect non-www to www with .htaccess – Come redirigere non-www to www tramite .htaccess

Problem: How to redirect any requests from http://my-domain.com to http://www.my-domain.com. There are several benefits from doing that: Solution: Applied to: Linux apache. Log on your server and tries on website folder the .htaccess file and edit it: RewriteEngine On RewriteCond %{HTTP_HOST} !^www\. RewriteRule ^(.*)$ http://www.%{HTTP_HOST}/$1 [R=301,L] Well done! Best Regards, ITquadro – specialized Blog ITquadro sistemisti specializzati …

How to redirect non-www to www with .htaccess – Come redirigere non-www to www tramite .htaccessLeggi altro »

The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)

Problem: When you try to delete user from database through Microsoft SQL Server Management Studio you might stumble in the follow error: “Drop failed for User ‘user’. (Microsoft.SqlServer.Smo).” “The database principal owns a schema in the database, and cannott be dropped” In simple terms, the user you want to delete has the property of one or more schema. …

The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)Leggi altro »

How to install vSphere client 4.1 on windows 8 – Come installare vSphere client 4.1 su windows 8

Problem: If you try to install vSphere client 4.1 on windows 8 you can encounter in the following error: “This product can only be installed on Windows XP Sp2 and above” Solution: Right click VMware-viclient.exe and choose Properties. Go to Compatibility tab, and check the option “Run this program in compatibility mode for” and pick Windows 7 from the list. Best …

How to install vSphere client 4.1 on windows 8 – Come installare vSphere client 4.1 su windows 8Leggi altro »

Show user grant/permissions on MySQL – Visualizza i permessi di un utente mysql

First, log into the mysql shell as a privileged user: root@localhost:~# mysql -u root -p Now, execute the follow command to view permission of the USER on localhost: mysql> SHOW GRANTS FOR USER@”localhost”; Well done! Best Regards, ITquadro – specialized Blog ITquadro sistemisti specializzati su Bologna ed Emilia-Romagna esperti in installazione e configurazione di MySQL ed …

Show user grant/permissions on MySQL – Visualizza i permessi di un utente mysqlLeggi altro »

How to reset root password on debian (linux) – Come resettare la password di root su linux debian

Solution: Reboot machine. On Grub screen press “e” to edit boot. On “Loading linux kernel” add in the end init=/bin/bash or init=/bin/sh (see the screenshot) mount -n -o remount,rw / if it didn’t work, you can try: mount -n -o remount-rw / passwd (insert new password twice) reboot Best Regards, ITquadro – specialized Blog ITquadro consulenti informatici …

How to reset root password on debian (linux) – Come resettare la password di root su linux debianLeggi altro »