February 7, 2003 at 5:56 am
Hi, people.
I have a ~90GB database, with 22 files (4GB each). Once a month, I
perform a full database backup and restore to other server, WITH
STANDBY. So, every bussiness day I execute 2 BACKUP LOG (12:30PM and
10PM) and restore over my standby database. My SQL version is 7.0
Standard with SP4 (the backup/restore precess is implemented in a set
of jobs).
This week my datafiles has >95% full, so I think "I'll create other
4GB datafile". I not create the datafile yet, because in BOL there's a
topic about error 3155 (The RESTORE operation cannot proceed because
one or more files have been added or dropped from the database since
the backup set was created).
In my (humble) opinion, if I add a datafile, then my RESTORE LOG
statments will fail, am I right? If yes, there's a way to avoid this
error and don't "brake" my RESTORE LOG chain?
Thanks in advance for any help.
_______________________________
Marcelo L Guimaraes
February 7, 2003 at 9:38 am
I think this will cause an issue. Can you not take a full backup and move that over after the new file?
Steve Jones
February 10, 2003 at 5:40 am
Thanks Steve.
But I want avoid perform a full backup, because disk space to do this is limited(only 78GB free). My last backup (last weekend) was a "fight" against ever-growing files.
Thanks again.
Marcelo
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply