Backup and restore MS SQL database with SQL query

In Microsoft SQL Server Management Studio, you can backup and restore your database on graphic user interface. But, sometimes, you will see some problems with some database/backup file which isn't on your PC. Then, SQL query maybe useful for you.

Backup database to file:

BACKUP DATABASE your_database_name
TO DISK = '\\your_pc_name\shared_folder\your_database_name.bak'

Restore database from file:
- Get old file list in your backup file:

RESTORE FILELISTONLY
FROM DISK = '\\other_pc_name\shared_folder\your_database_name.bak'

Restore database with LogicalName from result list

RESTORE DATABASE new_database_name
FROM DISK = '\\other_pc_name\shared_folder\your_database_name.bak'
WITH MOVE 'LogicalName of data' TO 'C:\new_database_name.mdf'
,MOVE 'LogicalName of log' TO 'C:\new_database_name_log.ldf'

Run another app on iOS by object-C code

When you are coding in object-C for iOS, you may wonder how to run another app by code. We have a simple step to do that by using app's BundleURLSchemes.

Insert Google Search box into blog/website

Normally, every blog/website has a search function which supports everyone to easily browse the site contents. But it maybe not really useful and effective. Then Google Custom Search is a brilliant choice for you. How to get it?

Access Facebook.com with Google DNS and hosts file

Facebook is now the most popular social network. You have many friends and many informations which need to be check on it. But a day, you can't access Facebook or can't post an image. You can resolve this problem by simple steps:

SomeT.I.P.

Search This Blog