Board index MS SQL Server

Back-ups

Back-ups

Post by Szatkowski, Ernes » Sat, 01 Apr 2000 04:00:00



Veritas (formerly Seagate Software) has a back-up solution that is
Cluster aware.
It is called Veritas Back-up Exec. It is not cheap but , It will do the
trick. I also would not recommend the ARCServe product. I personally
have not ever used it but people I know have and they don't care for it
at all. www.veritas.com

Ernie

-----Original Message-----

Posted At: Friday, January 28, 2000 1:14 PM
Posted To: clustering
Conversation: Backup solutions
Subject: Backup solutions

For those of you who have deployed SQL 6.5 or 7.0 in a cluster, what
software and hardware are you using to back your database and servers up
with? I'm not sure what products that are on the market are cluster
aware
and want to narrow my choices down a little bit. I'm looking at CA
ArcServeIT with the SQL Agent, but I'm not sure how this combo will work
with MSCS.

Thoughts or hints appreciated

Steve Fuller

 
 
 
Top

1. Backup from filegroup without transaction log backups

I have a mssql 7.0 database of 2 GB (it will probably grow to 5 GB). In
this database I have approximately 130 tables. Every night I make a
full backup. Sometimes I get called that the data updated in an table
over the last month is totally wrong. The table needs to be recovered
to the state it was in the previous month.

In mssql 6.5 I restored just that one table. In mssql 7.0 this is not
possible any more. The server is not big enough to contain 2 databases
of 5 GB.

I have the following solution. I know which tables can cause problems.
I want to put these tables on there own file group. If I have to
restore a table I restore that filegroup. However I dont have the
transaction log backups from the previous month.

Question will the database be consistent without the transaction log
backups?

Sent via Deja.com http://www.deja.com/
Before you buy.

2. I stand corrected

3. Backup Exec Full DB Backup

4. SQL Server 7 - How do you get Identity value when doing an insert

5. Can't backup database to remote backup device

6. Change column size

7. Sql Backup using TZ-88 Tape backup

8. US CA Sacramento - Foxpro Programmer/Developer

9. Backup Command - expiry of backups

10. Problem with Full backup and Differential backup reference

11. Differential backups larger than full backups?

12. Database backup / database File Backup

13. Backups: Large full backups fail


All times are UTC
Board index