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'

[Titanium] show confirm messagebox

Titanium is a cross-platform framework based on javascript. So, you can simple show an alert messagebox by normal javascript code:

Dislay snow effect on your blog/website

When Christmas season is going to come, many blog/website masters will want to make a change on their website interface. If you want to display snow storm effect on your site, you just need use below simple steps with Javascript to do that.

Remove Hosting24 Analytics Code in website hosted on 000webhost

When you registered and hosted your websites on 000webhost.com , you manage and publish them. Everything seems normally. Your websites will operate without any problem. However, some security services and web browsers sometimes detect something as a malware at an javascript line code. Like this:

SomeT.I.P.

Search This Blog