Backing up Web server 
Author Message
 Backing up Web server

Hello everyone. We have SQL Server 2000 running on our Web
server. We use Retrospect 5.5 to automatically back up the
server every night. Retrospect is not backing up the SQL Data
Files (path name: \MS SQL Data Files\MSSQL\Data\the file
name.ldf or .mdf). I am told this is because SQL is running and
has a lock on those files and won't release the lock so
Retrospect can back them up. Is there a way to get SQL to
release those data files so they can be backed up? My SQL guru
says no, without quitting the application. We need Retrospect to
back up everything on the server, including the SQL files. (I am
aware that SQL has a built-in backup feature, but we're looking
for something that can handle backing up everything on the
server, not just the SQL files.) This is not good because we're not
getting backups of the SQL data files, which would hurt us if we
lost the files.

My only other thought would be to do a separate, manual
backup first thing in the a.m., using a separate DLT tape and
using SQL's backup program. Yuk. What a pain. Any thoughts
from anyone? I really appreciate it.

kind regards,
Linda
Atlanta, GA



Tue, 09 Dec 2003 05:29:21 GMT
 Backing up Web server

If your database is small then you can have SQL Server do a backup to a disk
file prior to the scheduled tape backup.  This disk file would then be
backed up to tape. For large databases, this is not an option

Or you could switch backup programs to something like Veritas which offers a
SQL connector that will do "live" backups


Quote:
> Hello everyone. We have SQL Server 2000 running on our Web
> server. We use Retrospect 5.5 to automatically back up the
> server every night. Retrospect is not backing up the SQL Data
> Files (path name: \MS SQL Data Files\MSSQL\Data\the file
> name.ldf or .mdf). I am told this is because SQL is running and
> has a lock on those files and won't release the lock so
> Retrospect can back them up. Is there a way to get SQL to
> release those data files so they can be backed up? My SQL guru
> says no, without quitting the application. We need Retrospect to
> back up everything on the server, including the SQL files. (I am
> aware that SQL has a built-in backup feature, but we're looking
> for something that can handle backing up everything on the
> server, not just the SQL files.) This is not good because we're not
> getting backups of the SQL data files, which would hurt us if we
> lost the files.

> My only other thought would be to do a separate, manual
> backup first thing in the a.m., using a separate DLT tape and
> using SQL's backup program. Yuk. What a pain. Any thoughts
> from anyone? I really appreciate it.

> kind regards,
> Linda
> Atlanta, GA



Tue, 09 Dec 2003 06:24:08 GMT
 Backing up Web server
Hi

the suggestion form "user" is  pretty much what it sounds like you are after
...

Veritas has a product "Sql agent" that allows you to perform a sql db backup
to the extent of the individual filegroups etc in sql that comprise your
database. Alternately consider the disk backup with sql and then backing
this up with your enterprise backup solution.
This depends on your db size though ....

Good luck ...


Quote:
> Hello everyone. We have SQL Server 2000 running on our Web
> server. We use Retrospect 5.5 to automatically back up the
> server every night. Retrospect is not backing up the SQL Data
> Files (path name: \MS SQL Data Files\MSSQL\Data\the file
> name.ldf or .mdf). I am told this is because SQL is running and
> has a lock on those files and won't release the lock so
> Retrospect can back them up. Is there a way to get SQL to
> release those data files so they can be backed up? My SQL guru
> says no, without quitting the application. We need Retrospect to
> back up everything on the server, including the SQL files. (I am
> aware that SQL has a built-in backup feature, but we're looking
> for something that can handle backing up everything on the
> server, not just the SQL files.) This is not good because we're not
> getting backups of the SQL data files, which would hurt us if we
> lost the files.

> My only other thought would be to do a separate, manual
> backup first thing in the a.m., using a separate DLT tape and
> using SQL's backup program. Yuk. What a pain. Any thoughts
> from anyone? I really appreciate it.

> kind regards,
> Linda
> Atlanta, GA



Tue, 09 Dec 2003 20:14:10 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Back-Up Power for servers,UPS, Generators

2. SQL Server 6.5 Back ups

3. Back-ups to Disk?

4. best way to make incremental back-ups?

5. scheduled back-ups

6. Database Back-ups Contending with On-Line Transactions

7. Copyng Back Ups ?

8. Logical log back-ups

9. Logical log back-ups to disk using ontape

10. Hot Back-ups from Raw File Systems

11. Converting full database back-ups to Flat Files

12. Scripted back-ups?


 
Powered by phpBB® Forum Software