Tag Archives: sqlserver

VDI Client on Linux

Prerequisites for building the VDI client Download SLES release of llvm + clang from http://releases.llvm.org/ tar -xvf clang+llvm-5.0.1-linux-x86_64-sles12.2.tar.xz Install libuuid-devel from SDK or Suse repo. export PATH=/home/tony/clang+llvm-5.0.1-linux-x86_64-sles12.2/bin/:$PATH cd /home/tony/sandbox/tsm/sqlvdi-linux LD_LIBRARY_PATH=”/opt/mssql/lib” make -f Makefile   Run vdisample https://github.com/Microsoft/sql-server-samples/tree/master/samples/features/sqlvdi-linux https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-backup-vdi-specification   Run … Continue reading

Posted in linux, sql.server | Tagged , , | Leave a comment

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