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      C