Post reply

Database Success or failure

  • December 24, 2011 at 10:26 am

    #265356

    Hi Guys.....

    1. When we are using backup strategy or maintenance plan strategy then at that time how do we come know that our database is failure or success ?

    2. Can we run a full backup without interrupting LSN(Log Sequence Number) ?

    3. Also in database mail configuration which port is used?

    Reply....Thanks

  • December 24, 2011 at 11:16 am

    #1425350

    1. When we are using backup strategy or maintenance plan strategy then at that time how do we come know that our database is failure or success ?

    -You can check failure or success in maintenance plan or job history.

    2. Can we run a full backup without interrupting LSN(Log Sequence Number) ?

    - you can run log backups and simultaneous full backups. They don’t block each other ( SQL server 2005 on wards)

    3. Also in database mail configuration which port is used?

    -Mostly port 25 is used and its comes by default in the configuration.

    java[/url]

  • December 24, 2011 at 11:20 am

    #1425351

    Thanks......buddy.....

  • December 24, 2011 at 11:32 am

    #1425354

    Welcome !!:-)

    java[/url]

  • December 25, 2011 at 3:11 am

    #1425404

    yes, that is right.... regarding LSN, didn't know if the context was log shipping.. If so, the log shipping will be fine, no issues with full backups as salum mentioned..

  • December 25, 2011 at 7:05 pm

    #1425447

    Saggy (12/24/2011)

    2. Can we run a full backup without interrupting LSN(Log Sequence Number) ?

    I'm not sure if that's what you want but you can use BACKUP DATABASE <etc.> WITH COPY_ONLY.

    Best regards,

    Best regards,

    Andre Guerreiro Neto

    Database Analyst
    http://www.softplan.com.br
    MCITPx1/MCTSx2/MCSE/MCSA

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply