Skip to content
Home » restore

restore

Visit Tacticalware.com for information related to this tag and others. We look forward to assisting in your tech projects with our in-depth knowledgebase…

CREATING A LOCAL MSSQL SERVER ON YOUR W10 PC

From time to time you will need to utilize a local sql server, for dev, testing, education, whatever. So here is a quick how-to on creating a local mssql server on your W10 pc.

Download and install the free version of SQL, called SQL Express:
https://www.microsoft.com/en-us/sql-server/sql-server-downloads
Accept all the defaults, except for these few
Use your credentials when prompted
Select all packages to be installed

Once SQL Express is installed, download and install SQL Server Management Studio
https://aka.ms/ssmsfullsetup

Now you have both installed, open SQL Server Management Studio or SSMS for short, and connect to your local SQL Express Database
Connect to “localhost\sqlexpress“
You dont have to put in any credentials if you selected to use your credentials earlier.

To do a test on the database, try restoring the AdventureWorksDW database
Right click on Databases
Select Restore database
Select the AdventureWorksDW file
Click Ok

You can now connect into your database using Power BI or another tool, and start playing around.

Thanks for reading

Restoring a Raspberry Pi Backup

This is a quick how to on restoring a backed up image to your SD Card Plug the SD Card into your MAC Go to Spotlight (the little magnifying glass on the top right of your MAC), type Terminal, and press Enter Now the rest of the commands are done in the Terminal Type: sudo bash and press enter Type in your password to get the # prompt Type: cd /raspberry-pi/backups and press enter Type df -h and look for your SD Card. My card is listed as /dev/disk1s1. Once you know which card is your SD Card type diskutil unmount /dev/disk1s1 (or whatever your SD Card is listed as) dd bs=1m if=/raspberry-pi/backups/wheezy-todaysdate-backup.img of=/dev/rdisk1 and press enter your SD Card will now be restore the backup Once the backup is complete type: diskutil eject /dev/rdisk1 And that is it. Thanks for reading Hardware that I use: Raspberry Pi 4 (4gb) https://amzn.to/3q551IO SanDisk 32GB Ultra microSDHC UHS-I Memory Card with Adapter https://amzn.to/2Vfvo0y CanaKit 3.5A Raspberry Pi 4 Power Supply (USB-C) https://amzn.to/3fNTYPu CanaKit Raspberry Pi 4 Micro HDMI Cable – 6 Feet https://amzn.to/33u5hr9 Western Digital 500GB WD_Black SN750 NVMe https://amzn.to/3nZ5pH4 Plugable USB C to M.2 NVMe Tool-free Enclosure https://amzn.to/3lflV3L