Simple and fast backup of SQL Server database

Question

I am looking for a simple (easiest, if possible) way to backup and restore a database.

I want to make a backup in one state, and then after some operations return to the backup state.

Trial database> Tasks-> Backup ... and then Database-> Tasks-> Restore, but I always get the error message:

Restore failed for...DBName

The tail of the log for the database "database name" has not been backed up...

So, I want to backup and restore with one simple operation, can I advise me on a solution, be it a GUI or not a GUI?

Answer 1

, . , .

http://msdn.microsoft.com/en-us/library/ms175510.aspx

, , DBA, DBA, .

:

COPY_ONLY , .

http://msdn.microsoft.com/en-us/library/ms186865.aspx

Answer 2

WITH REPLACE RESTORE:

REPLACE , . :

• . REPLACE, restore , , . .
• STOPAT . REPLACE , , , .
• . , , .xls , . , , .

MSDN, . , " ", , Management Studio (.. , ).

Answer 3

" ", , .

MSSQL 2005 , , .