Highlighted

backup sql database

Hi,

We have two SQL servers mirrored. There is one DB used by both the servers.

Now if I have to backup the database how should I proceed? Both the clients will be involved or only one (what I think)?

Overall how does this work?

Thanks.

2 Replies

Re: backup sql database

Re: backup sql database

Make sure you don't exclude, but do include two (per instance) important files in your backups, as per:

https://msdn.microsoft.com/en-gb/library/ms190940.aspx