Any side effects from backing up DB and log at the same time?

Hi,
Do you know of any other possible dangers, apart from transaction log backup
not being made and waiting for the full DB backup to complete, when letting
the transaction log backup run during the full DB backup?
What else besides the failing transaction log backup can happen when making
the backup during the time the database is in simple recovery mode?
-- Many, thanks. Oskar.
in simple rm t-log backup useless
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:4B5DCB3A-80B3-4E06-9633-9E6886BD9273@.microsoft.com...
> Hi,
> Do you know of any other possible dangers, apart from transaction log
> backup
> not being made and waiting for the full DB backup to complete, when
> letting
> the transaction log backup run during the full DB backup?
> What else besides the failing transaction log backup can happen when
> making
> the backup during the time the database is in simple recovery mode?
> -- Many, thanks. Oskar.

Any side effects from backing up DB and log at the same time?

Hi,
Do you know of any other possible dangers, apart from transaction log backup
not being made and waiting for the full DB backup to complete, when letting
the transaction log backup run during the full DB backup?
What else besides the failing transaction log backup can happen when making
the backup during the time the database is in simple recovery mode?
-- Many, thanks. Oskar.in simple rm t-log backup useless
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:4B5DCB3A-80B3-4E06-9633-9E6886BD9273@.microsoft.com...
> Hi,
> Do you know of any other possible dangers, apart from transaction log
> backup
> not being made and waiting for the full DB backup to complete, when
> letting
> the transaction log backup run during the full DB backup?
> What else besides the failing transaction log backup can happen when
> making
> the backup during the time the database is in simple recovery mode?
> -- Many, thanks. Oskar.

Any side effects from backing up DB and log at the same time?

Hi,
Do you know of any other possible dangers, apart from transaction log backup
not being made and waiting for the full DB backup to complete, when letting
the transaction log backup run during the full DB backup?
What else besides the failing transaction log backup can happen when making
the backup during the time the database is in simple recovery mode?
-- Many, thanks. Oskar.in simple rm t-log backup useless
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:4B5DCB3A-80B3-4E06-9633-9E6886BD9273@.microsoft.com...
> Hi,
> Do you know of any other possible dangers, apart from transaction log
> backup
> not being made and waiting for the full DB backup to complete, when
> letting
> the transaction log backup run during the full DB backup?
> What else besides the failing transaction log backup can happen when
> making
> the backup during the time the database is in simple recovery mode?
> -- Many, thanks. Oskar.

Any issues with using Noton Ghost with SQL Server?

I seem to recall from reading an article that there are issues with backing
up hard drives with Norton Ghost with SQL Server or MSDE installed.
However, I can't seem to find the KB article. Can someone confirm this with
resource articles?
Thanks in advance.The issue is most likely if your trying to do this while SQL Server is
running. If it's not running I don't see why you couldn't ghost it but that
is not a very efficient way to backup sql server.
--
Andrew J. Kelly
SQL Server MVP
"wym" <wym@.sympatico.ca> wrote in message
news:Doxub.9670$iT4.1045873@.news20.bellglobal.com...
> I seem to recall from reading an article that there are issues with
backing
> up hard drives with Norton Ghost with SQL Server or MSDE installed.
> However, I can't seem to find the KB article. Can someone confirm this
with
> resource articles?
> Thanks in advance.
>|||Thank you for the reply. Actually, the question came up because our
application uses MSDE 2000 and it is set to autostart when OS starts. When
customers backup with with Ghost, I doubt they will turn off MSDE (they will
have to search for it since SQL Server Service Manager is not in the tray).
If they reinstall the image, will there be any issues with MSDE or the
databases?
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OvHVoHjrDHA.2408@.tk2msftngp13.phx.gbl...
> The issue is most likely if your trying to do this while SQL Server is
> running. If it's not running I don't see why you couldn't ghost it but
that
> is not a very efficient way to backup sql server.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "wym" <wym@.sympatico.ca> wrote in message
> news:Doxub.9670$iT4.1045873@.news20.bellglobal.com...
> > I seem to recall from reading an article that there are issues with
> backing
> > up hard drives with Norton Ghost with SQL Server or MSDE installed.
> > However, I can't seem to find the KB article. Can someone confirm this
> with
> > resource articles?
> >
> > Thanks in advance.
> >
> >
>|||You can't guarantee a consistent database by backing up at the file level
when sql server is running. I would look into writing some simple BACKUP
and RESTORE scripts. They work the same on MSDE as they do on any edition
and are the correct way to backup the databases.
--
Andrew J. Kelly
SQL Server MVP
"wym" <wym@.sympatico.ca> wrote in message
news:HKzub.10072$iT4.1118306@.news20.bellglobal.com...
> Thank you for the reply. Actually, the question came up because our
> application uses MSDE 2000 and it is set to autostart when OS starts.
When
> customers backup with with Ghost, I doubt they will turn off MSDE (they
will
> have to search for it since SQL Server Service Manager is not in the
tray).
> If they reinstall the image, will there be any issues with MSDE or the
> databases?
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:OvHVoHjrDHA.2408@.tk2msftngp13.phx.gbl...
> > The issue is most likely if your trying to do this while SQL Server is
> > running. If it's not running I don't see why you couldn't ghost it but
> that
> > is not a very efficient way to backup sql server.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "wym" <wym@.sympatico.ca> wrote in message
> > news:Doxub.9670$iT4.1045873@.news20.bellglobal.com...
> > > I seem to recall from reading an article that there are issues with
> > backing
> > > up hard drives with Norton Ghost with SQL Server or MSDE installed.
> > > However, I can't seem to find the KB article. Can someone confirm
this
> > with
> > > resource articles?
> > >
> > > Thanks in advance.
> > >
> > >
> >
> >
>