Dird (6/16/2013)

---

drnorbert (6/16/2013)

---

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

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

I don't understand your question. The statement you ran backed up the database. To backup the transaction log you would need to use a different command (BACKUP LOG) to a different file on disk. You will need to use a scheduled job to backup them automatically on a regular basis (e.g. database backup 1 time per day; log backup every 15 minutes).

drnorbert (6/16/2013)

---

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

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

Message:

Use WITH FORMAT to create a new mirrored backup set.

Because you already used db.bak for a non-mirrored backup you must recreate the formatting. The first time you run it use:

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

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

After the first time you can remove the WITH FORMAT option.

drnorbert (6/16/2013)

---

Do I need to shrink the DB?

No.

Edit: To attach the text you click the "Quote" button instead of "Reply" but then I make them shorter by adding extra (quote) (/quote) statements and deleting text that isn't important.