SQL Server Performance

Database Success or Failure

Discussion in 'ALL SQL SERVER QUESTIONS' started by Sagir, Dec 24, 2011.

  1. Sagir New Member

    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?

  2. MichaelB Member

    Firstly, welcome to our forums!

    1. Your database is failure or the backup is failed? if the backup is failed it will indicate this in the database error logs.
    2. Before running a full backup run a t-log backup to capture any transactions since your last t-log backup. LSN will be fine. it should change with each full backup.. all t-log backups are based on the last full LSN
    3. Depends on what you have setup. port 25 is default i think
  3. Luis Martin Moderator

    3. Yeap, 25 is default.
  4. MichaelB Member

    Cool. thought so. Thanks Luis.

Share This Page