SQLTeam.com | Weblogs | Forums

Backup Principle database

sql2005

#1

we have set up database mirroring SQL 2005.
can i take full backup principle database ? does it break database mirroring if i will take full backup of Principle database ?


#2

I'm pretty sure that you can take a full backup using the COPY ONLY option of backup. It doesn't show up in the GUI's for 2005. You have to write the command and include it.


#3

Unless I'm missing something you can take full backups of principle databases normally. Are you also doing transaction log backups?


#4

Hii Graz

I am just taking a full database backup of my principal database