Category Archives: sql.server

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