How to recover deleted files on micro SD card?

Puran File Recovery is a free file recovery program.

https://www.lifewire.com/puran-file-recovery-review-2622882

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

System Rescue Boot Disc

https://www.raymond.cc/blog/5-system-rescue-boot-disc-based-on-windows-pe/

http://www.online-tech-tips.com/computer-tips/backup-your-computer-by-making-an-image-of-your-hard-drive/

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

Windows 10 Editions and Cortana

https://www.microsoft.com/en-gb/windowsforbusiness/compare

https://www.itechtics.com/difference-between-windows-10-pro-vl-n-editions/

https://en.wikipedia.org/wiki/Windows_10_editions

https://support.microsoft.com/en-gb/help/17214/windows-10-what-is

 

Posted in windows | Tagged , , | Leave a comment

List of Backup Software

https://en.wikipedia.org/wiki/List_of_backup_software

Posted in storage | Tagged , | Leave a comment

The IDE does not take in consideration the new project constant value in the Visual Studio project

Issue:  The macro inside the cs files remains with old value instead of taking in consideration the new value set in the ImportProject.

For example, in the dp.client.csproj file there is this import

 <Import Project="..\..\common\winnt\build\common.props" />

The common.props does define constant

 <BUILDFLAGVER Condition="'$(BUILD_TSM_VERSION)'=='814'">BUILD_TSM_V814</BUILDFLAGVER>

Inside the SqlServerManager.cs

 switch (spiu)
 {
#if (BUILD_TSM_V714 || BUILD_TSM_V713 || BUILD_TSM_V712)
 case SqlProductInUse.SQL2008:
 case SqlProductInUse.SQL2008Plus:
 case SqlProductInUse.SQL2008SP1:
 case SqlProductInUse.SQL2008SP1Plus:
 case SqlProductInUse.SQL2008SP2:
 case SqlProductInUse.SQL2008SP2Plus:
 case SqlProductInUse.SQL2008SP3:
 case SqlProductInUse.SQL2008SP3Plus:
 case SqlProductInUse.SQL2008R2:
 case SqlProductInUse.SQL2008R2Plus:
 case SqlProductInUse.SQL2008R2SP1:
 case SqlProductInUse.SQL2008R2SP1Plus:
 case SqlProductInUse.SQL2008R2SP2:
 case SqlProductInUse.SQL2008R2SP2Plus:
 case SqlProductInUse.SQL2012:
 case SqlProductInUse.SQL2012Plus:
 case SqlProductInUse.SQL2012SP1:
 case SqlProductInUse.SQL2012SP1Plus:
 case SqlProductInUse.SQL2014:
 case SqlProductInUse.SQL2014Plus:
 supportedVersion = true;
 break;
#elif (BUILD_TSM_V716)
 case SqlProductInUse.SQL2008:
 case SqlProductInUse.SQL2008Plus:
 case SqlProductInUse.SQL2008SP1:
 case SqlProductInUse.SQL2008SP1Plus:
 case SqlProductInUse.SQL2008SP2:
 case SqlProductInUse.SQL2008SP2Plus:
 case SqlProductInUse.SQL2008SP3:
 case SqlProductInUse.SQL2008SP3Plus:
 case SqlProductInUse.SQL2008R2:
 case SqlProductInUse.SQL2008R2Plus:
 case SqlProductInUse.SQL2008R2SP1:
 case SqlProductInUse.SQL2008R2SP1Plus:
 case SqlProductInUse.SQL2008R2SP2:
 case SqlProductInUse.SQL2008R2SP2Plus:
 case SqlProductInUse.SQL2012:
 case SqlProductInUse.SQL2012Plus:
 case SqlProductInUse.SQL2012SP1:
 case SqlProductInUse.SQL2012SP1Plus:
 case SqlProductInUse.SQL2014:
 case SqlProductInUse.SQL2014Plus:
 case SqlProductInUse.SQL2016:
 case SqlProductInUse.SQL2016Plus:
 supportedVersion = true;
 break;
#elif (BUILD_TSM_V810 || BUILD_TSM_V812)
 case SqlProductInUse.SQL2014:
 case SqlProductInUse.SQL2014Plus:
 case SqlProductInUse.SQL2016:
 case SqlProductInUse.SQL2016Plus:
 supportedVersion = true;
 break;
#else
 case SqlProductInUse.SQL2014:
 case SqlProductInUse.SQL2014Plus:
 case SqlProductInUse.SQL2016:
 case SqlProductInUse.SQL2016Plus:
 case SqlProductInUse.SQL2017:
 case SqlProductInUse.SQL2017Plus:
 supportedVersion = true;
 break;
#endif
 case SqlProductInUse.Unknown:
 default:
 supportedVersion = false;
 break;
 }

Solution:  Rename / drop the fm.ux.v11.suo file. The solution seems to recreate the fm.ux.sdf file.

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

Dot.Net and PowerShell

PS C:\Users\IBM_ADMIN> [IO.Path]::GetTempPath()
C:\windows\TEMP\

Posted in develop | 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 do a restore, if any other user is in the database you will see these types of error messages:

T-SQL

Msg 3101, Level 16, State 1, Line 1
Exclusive access could not be obtained because the database is in use.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

SSMS


Getting Exclusive Access

To get exclusive access, all other connections need to be dropped or the database that they are in needs to be changed so they are not using the database you are trying to restore.  You can use sp_who2 or SSMS to see what connections are using the database you are trying to restore.

Using KILL
One option to get exclusive access is to use the KILL command to kill each connection that is using the database., but be aware of what connections you are killing and the rollback issues that may need to occur.  See this tip for more information on how to do this.

Using ALTER DATABASE
Another option is to put the database in single user mode and then do the restore.  This also does a rollback depending on the option you use, but will do all connections at once.  See this tip for more information on how to do this.

ALTER DATABASE AdventureWorks SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
RESTORE DATABASE AdventureWorks FROM DISK = 'C:\AdventureWorks.BAK' 
GO
Posted in sql.server | Tagged | Leave a comment