SQL - How to backup SQL database and run query from command line

If you need to backup SQL database and you have not SQL Management Studio you can do that through command line:

SQLCMD -S SqlServerName\SqlInstanceName

BACKUP DATABASE VeeamBackup TO DISK = 'C:\BackupDB2016.06.09.bak'

quit

If you need to run sql script you can proceed in this way:

SQLCMD -S SqlServerName\SqlInstanceName -i C:\temp\sqlscript.sql -o

C:\temp\sqlscript.txt

SQL management Studion download you can review this veeam article where I copied and paste text:

https://www.veeam.com/kb1761

You can get SQL Management Studio here:

2014: http://www.microsoft.com/en-us/download/details.aspx?id=42299 (MgmtStudio 64BIT\SQLManagementStudio_x64_ENU.exe)

2012: http://www.microsoft.com/en-us/download/details.aspx?id=29062 

2008 R2: http://www.microsoft.com/en-us/download/details.aspx?id=22985

2008: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=08e52ac2-1d62-45f6-9a4a-4b76a8564a2b&displaylang=en

2005: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796

An official Microsoft blog below shows step by step guides on performing this install:
http://blogs.msdn.com/b/bethmassi/archive/2011/02/18/step-by-step-installing-sql-server-management-studio-2008-express-after-visual-studio-2010.aspx

Print Server - Windows 7 cannot connect to the printer 0x0000007e

On 32 bit pcs when they tried to add a shared printer from print server we got this error 0x0000007e

PROBLEM: Windows 7 64-bit stations can not add HP LaserJet P4015n from print serverWindows Server 2003 R2 showing the error 0x000007e

SOLUTION: On the print server, delete the registry key 

"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Print\Printers\[PrinterName]\CopyFiles\BIDI"

CAUSE: The station of user was trying to access a path that the 64-bit operating systems do not recognize as valid: "spool\drivers\w32x86\3". This path is set in the printer settings on the Print Server.


https://social.technet.microsoft.com/Forums/windowsserver/en-US/6c68f4d3-fa4c-4986-9567-bbe89551652f/windows-7-windows-cannot-connect-to-the-printer-0x0000007e

Manuals - Gutenberg Project

Project Gutenberg offers over 50,000 free ebooks: choose among free epub books, free kindle books, download them or read them online.

They carry high quality ebooks: Their ebooks were previously published by bona fide publishers. They digitized and diligently proofread them with the help of thousands of volunteers.
No fee or registration is required.

http://www.gutenberg.org/wiki/Main_Page 

Manuals - Free ebook: Windows 10 IT Pro Essentials Support Secrets

This ebook is for anyone whose responsibilities include training people to use Windows 10.

That group includes full-time professional trainers, of course, but it also includes IT pros and those brave souls who staff the help desk in corporations. Most of all, it includes the incredibly large population of people who have earned a reputation for being “the person who knows Windows.”

With that knowledge comes a seemingly endless stream of questions from friends, family, and coworkers. As Windows 10 moves into its second full year and begins to take over an increasing share of the installed base of PCs, many of those questions are going to begin “How do I…”

That’s where this ebook comes in. My goal here is to introduce the building blocks of Windows 10 to you in a way that can help you answer those questions quickly. It also offers the kind of information you need to go one step further, offering the kind of extended details about how Windows 10 works that might, just might, answer that next question before it’s even asked.

I’m grateful to the developers and designers at Microsoft who are building Windows 10, for giving me an operating system that’s fun to write about. I’d also like to thank Microsoft Press, which gave me complete editorial independence for this project. Every word in this book comes from my personal experience. I hope you find it useful.

I encourage you to share your feedback about this book directly with me. Email your comments to me at


download:

https://blogs.msdn.microsoft.com/microsoft_press/2016/07/14/free-ebook-windows-10-it-pro-essentials-support-secrets/

Tips - AnyConnect was not able to establish a connection to the specified secure gateway. Please try connect again

During these days i faced this problem:

Cisco Any connect and relatives configuration files was corretely installed and after VPN user and password insertion I got this error:

"AnyConnect was not able to establish a connection to the specified secure gateway. Please try connect again"

The solution was to verify that it was not checked this option:

SCCM 2012 - How to install AnyConnect VPN with SCCM 2012

http://www.alessandromazzanti.com/2015/01/sccm-2012-how-to-install-anyconnect-vpn.html

Tips - Locating the Cisco AnyConnect Profiles

http://www.alessandromazzanti.com/2015/01/tips-locating-cisco-anyconnect-profiles.html

Linux - Creare un Gateway Server

http://www.alessandromazzanti.com/2011/09/linux-creare-un-gateway-server.html

Backup - Fare il backup delle connessioni di rete e VPN

http://www.alessandromazzanti.com/2012/09/backup-fare-il-backup-delle-connessioni.html

Tips - Cisco VPN e Vodafone Connect Card

http://www.alessandromazzanti.com/2013/01/tips-cisco-vpn-e-vodafone-connect-card.html

Tips - Cisco errore Secure VPN Connection terminated locally by the Client. Reason 440: Driver Failure.

http://www.alessandromazzanti.com/2013/01/tips-cisco-errore-secure-vpn-connection.html

Tips - Cisco VPN 5.0 e Windows 8

http://www.alessandromazzanti.com/2013/07/tips-cisco-vpn-50-e-windows-8.html

Veeam 9 - HyperV 2012 R2 and public Lan Fault during backup

During last months we faced a strange problem on Cluster HyperV 2012 R2 VM backup.

Infact, randomly, with Veeam 9 we got a single hyperV public lan to be unreachable causing backup failure (Heartbit lan was working fine)

Here they are actions taken trying to solve issue:

1. When a single host was unreachable with public lan we connected to freeze host using Heartbeat lan via RDP. 

We stopped any Veeam processes and services to finish veeam backup (VM was always in backing up mode in HyperV console)

2. There was not any solution to put public lan to working again other than reboot host or disabling and renabling lan connection.

3. Backup faults happened again utilizing Veeam Throttling feature and using windows backup tools indeed than Veeam itself.

4. Finally we suspected that problem was related to lan driver itself.

Searching on internet Lan device name and server model we found that:

HP DL380 Gen8 servers as Windows 2012 R2 Hyper-V hosts and HP Ethernet 1Gb 4-port 331FLR / Broadcom NetXtreme

http://serverfault.com/questions/742520/any-known-fixes-for-hyper-v-host-networking-randomly-stops-responding

What really helped us in our case, was not only to disable the VMQ in all affected Network adapters properties as suggested by Microsoft, but also to disable it in the Virtual machine's properties (to uncheck “Enable Virtual Machine Queue” under each of the virtual machine settings). By default is it enabled.

From Miscrosoft Article:

https://support.microsoft.com/en-us/kb/2986895

Resolution

This issue is resolved in Broadcom driver b57nd60a.sys version 16.8 and newer. In March 2015, Broadcom published driver version 17.0 for download. In April 2015, HP published version 16.8 of the driver for their affected network adapters, here is one of their download locations. Please contact your server OEM if you need a driver that is specific to your server.

More information

If you are unable to update your network adapter driver to resolve the issue, you can work around the issue by disabling VMQ on each affected Broadcom network adapter by using the Set-NetAdapterVmq Windows PowerShell command. For example, if you have a dual-port network adapter, and if the ports are named NIC 1 and NIC 2 in Windows, you would disable VMQ on each adapter by using the following commands:

Set-NetAdapterVmq -Name "NIC 1" -Enabled $False
Set-NetAdapterVmq -Name "NIC 2" -Enabled $False
You can confirm that VMQ is disabled on the correct network adapters by using the Get-NetAdapterVmq Windows PowerShell command.

Note By default, VMQ is disabled on the Hyper-V virtual switch for virtual machines that are using 1-gigabit network adapters. VMQ is enabled on a Hyper-V virtual switch only when the system is using 10-gigabit or faster network adapters. This means that by disabling VMQ on the Broadcom network adapter, you are not losing network performance or any other benefits because this is the default. However, you need to do this to work around the driver issue.

Get-NetAdapterVmqQueue shows the virtual machine queues (VMQs) that are allocated on network adapters. You will not see any virtual machine queues that are allocated to 1-gigabit network adapters by default.

<----->

Other suggested blog articles

Recovery - Access, Excel, Word, Office and Photo recovery tools and other blog procedures

http://www.alessandromazzanti.com/2015/12/recovery-access-excel-word-office-and.html