Friday, March 23, 2012

Potential issues with backing up to a network share

Hi
What potential issues can you think of or have run into when making
transaction log backups into a single file on a network share. The
MSSQLSERVER service is running under a domain user account, which has
apropriate permissions on the shared folder. The backup is made from a
database in an MS SQL Server 2000 SP3 on an MS Windows Server 2003 SP1 and
the file is stored on an MS Windows 2000 Server SP4.
Many thanks,
Oskar
It's slow. If you have a busy OLTP and a large tran file, you can get
memory pressure during the backup. That being said we do it on many of our
servers.
"Oskar" <Oskar@.discussions.microsoft.com> wrote in message
news:ED49A03D-1FBC-42D2-84FA-C7987C0DF005@.microsoft.com...
> Hi
> What potential issues can you think of or have run into when making
> transaction log backups into a single file on a network share. The
> MSSQLSERVER service is running under a domain user account, which has
> apropriate permissions on the shared folder. The backup is made from a
> database in an MS SQL Server 2000 SP3 on an MS Windows Server 2003 SP1 and
> the file is stored on an MS Windows 2000 Server SP4.
> --
> Many thanks,
> Oskar
>

No comments:

Post a Comment