Author Archives: Tony

Getting exclusive access to a SQL Server database for restore

https://www.mssqltips.com/sqlservertutorial/82/getting-exclusive-access-to-a-sql-server-database-for-restore/ Overview When restoring a database, one of the things you need to do is ensure that you have exclusive access to the database.  If any other users are in the database the restore will fail. Explanation When trying to … Continue reading

Posted in sql.server | Tagged | Leave a comment

Recovering From SQL Server ‘recovery pending’ Status

Seeing a database in any state other than “online” makes me a little nervous. For one thing, it’s one of those things I don’t see often, so I have to rub a few brain cells together to remember what I … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Get the SQL Server database in the normal state

SQL Server Management Studio reports a database in “Recovery Pending” status. USE master ALTER DATABASE [dbname] SET OFFLINE WITH ROLLBACK IMMEDIATE ALTER DATABASE [dbname] SET ONLINE WITH ROLLBACK IMMEDIATE

Posted in Uncategorized | Tagged , | Leave a comment

SQL Connectivity Behavior

Connecting over the Network By default, the default protocol for SQL Server clients is TCP/IP. If the connection cannot be made using TCP/IP, the other enabled protocols are attempted. A shared memory connection cannot be made over a network. Use … Continue reading

Posted in develop | Tagged , | Leave a comment

VPN

https://www.expressvpn.com/

Posted in tools | Tagged | Leave a comment

Vodafone 6 Ultra OTA

This is Vodafone Smart Ultra 6 official firmware package. Download from the link below and use flashing instructions found at the end of the post to install the stock ROM to your smartphone. Downloads: Vodafone Smart Ultra 6 – Download … Continue reading

Posted in tools | Tagged , , , , | Leave a comment

Set an environment variable to the current working directory

The current directory is in the “shadow” variable cd called var. set “var=%cd%” set var

Posted in develop | Tagged , | Leave a comment