Re: Backing Up Mirrored database

Interesting...
Thanks Mohit! :-)

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Mohit K. Gupta" <mohitkgupta@xxxxxxx> wrote in message news:7621F481-9F20-4B88-88D6-63793B08F097@xxxxxxxxxxxxxxxx
Hi Tibor,

Correct I meant the later, it doesn't attempt to backup and hence no
error message, I am using MPs, and looks like they are smart enough to ignore
the partner databases. Thanks!

--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005


"Tibor Karaszi" wrote:

> I have backup job on both SQL Servers (principle and mirror) set to backup
> all databases; and both run successfully without any issues. SQL Server is
> smart enough to ignored mirrored databases if the job is on mirrored partner
> because databases are in Restoring mode.

Interesting... When you say "ignoring", do you mean
"Attempt to backup but receives an error message from the engine so the job fails"?
or
"Doesn't attempt to backup and hence nor error message"?

I guess the later, since you say "run successfully". I do know that if you try BACKUP DATABASE on a
mirrored database, you do get an error message. This is why I'm curious. Are you using Maintenance
Plans? If so, perhaps the MPs are smart enough to not attempt backing up a mirrored database?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi



.

Relevant Pages

  • Re: Backup job reported as failed
    ... databases in MS SQL Server 2005. ... Deletes old backup files ... In the job history for 'Nightly backup' is that job listed as passed ... Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books ... ...
    (microsoft.public.sqlserver.tools)
  • Re: Longest SQL runtime??
    ... What does "stop saving" mean? ... Do you get an error message at runtime, ... I have had much longer uptimes than that with databases measured in the ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Automating SQL Service start and shut down
    ... The best option would be using the Transact-SQL BACKUP command. ... make sure that you know how to restore/recover your data and your databases. ... Grab a tape, restore the files to a different server, and try to get the files restored. ... Moving SQL Server databases to a new location with Detach/Attach ...
    (microsoft.public.sqlserver.setup)
  • Re: Sharepoint DB maintenance?
    ... options to backup nightly. ... I am more concerned abouthe maintenance (i.e. SQL maintenance?) stuff. ... It's a good idea to back up the SPS databases regularly. ... on the server that is running SQL Server 2000." ...
    (microsoft.public.sharepoint.portalserver)
  • Backup questions
    ... and all of my databases are geochemical/hydrogeological ... My sys admin wants to use the backup procedure ... within SQL Server, but I really dont understand how the restoring works. ... can you restore the db's on another machine. ...
    (microsoft.public.sqlserver.security)