Hi Dird

I am trying to figure out how you are attaching my responses with your reply massages as well as the images such as:

🙂

Thanks for the details about setting up the Mail with live.com.

I am executing the query as per your instructions:

1)

Execute:

BACKUP DATABASE ISMDATA TO DISK='C:\ISMBACKUP\db.bak'

Message:

Processed 273864 pages for database 'ISMDATA', file 'ISMDATA_dat' on file 1.

Processed 1 pages for database 'ISMDATA', file 'ISMDATA_log' on file 1.

BACKUP DATABASE successfully processed 273865 pages in 58.470 seconds (36.592 MB/sec).

Is this means that the log is backup together with each execution or is a different command for the transaction log every 15 min?

2)

When add MIRROR I am getting an error msg.

Execute:

BACKUP DATABASE ISMDATA TO DISK='C:\ISMBACKUP\db.bak'

MIRROR TO DISK='\\Guardiavieja\ISMDATABU\db.bak'

Message:

Msg 3215, Level 16, State 1, Line 1

Use WITH FORMAT to create a new mirrored backup set.

Msg 3013, Level 16, State 1, Line 1

BACKUP DATABASE is terminating abnormally.

3)

Do I need to shrink the DB?