Hello Everyone,
We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
Windows 2003 Ent) from one subnet to another. Everything went well
(apparently) until we realized that our backups are failing (both the
existing jobs and manual backups) after the change in ip/subnet was
done. All backup attempts return with errrors similar to these:
===
18204 :
BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
failed to open. Operating system error = 32(The process cannot access
the file because it is being used by another process.).
===
3041 :
BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
===
When the manual backup is initiated without Verification, no (popup)
error is generated (but the error above is still logged on the event
log) and the backup says it ran successfully. When the backup file is
checked, the size is Zero (0) kb.
There is no apparent problem in connecting to both the two instances
of the server and applications are working okay, it's just the backup
problem that is bugging us.
drive Q = quorum
drive F = one of the shared drives with 20Gb+ remaining
The database that we are attempting to backup is just about 11Gb in
size.
Any help is appreciated.
Thanks.
AramidJust a quick question - were you backing up to a shared network drive
previously? What if you try backing up to the fully qualified UNC Path
instead?
"aramid" <aramid@.hotmail.com> wrote in message
news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.
4ax.com...
> Hello Everyone,
> We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
> Windows 2003 Ent) from one subnet to another. Everything went well
> (apparently) until we realized that our backups are failing (both the
> existing jobs and manual backups) after the change in ip/subnet was
> done. All backup attempts return with errrors similar to these:
> ===
> 18204 :
> BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
> failed to open. Operating system error = 32(The process cannot access
> the file because it is being used by another process.).
> ===
> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
> TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
> NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
> ===
>
> When the manual backup is initiated without Verification, no (popup)
> error is generated (but the error above is still logged on the event
> log) and the backup says it ran successfully. When the backup file is
> checked, the size is Zero (0) kb.
> There is no apparent problem in connecting to both the two instances
> of the server and applications are working okay, it's just the backup
> problem that is bugging us.
> drive Q = quorum
> drive F = one of the shared drives with 20Gb+ remaining
> The database that we are attempting to backup is just about 11Gb in
> size.
>
> Any help is appreciated.
> Thanks.
>
> Aramid
>|||Thanks for your reply, Michael.
We are not backing up to any shared network drive, just to this drive,
which is one of the logical drives on an external disk array attached
to the cluster.
Aramid
On Sun, 10 Apr 2005 23:56:13 -0400, "Michael C#" <xyz@.abcdef.com>
wrote:
>Just a quick question - were you backing up to a shared network drive
>previously? What if you try backing up to the fully qualified UNC Path
>instead?
>"aramid" <aramid@.hotmail.com> wrote in message
> news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.
4ax.com...
>|||aramid
It seems that is permission or OS issue . We have recently moved to the
cluster and what i did in the backup script only changed the D:\ Driver
path to N:\ driver path. Run SQL Server Profile to see what is going on.
Have you searched on internet for those errors?
"aramid" <aramid@.hotmail.com> wrote in message
news:0ouj51dm2esqntk6pegt6f37m36f4g8brj@.
4ax.com...
> Thanks for your reply, Michael.
> We are not backing up to any shared network drive, just to this drive,
> which is one of the logical drives on an external disk array attached
> to the cluster.
> Aramid
> On Sun, 10 Apr 2005 23:56:13 -0400, "Michael C#" <xyz@.abcdef.com>
> wrote:
>
>|||SQL Server say that the backup file is used by some other process. I'd get a
tool with which I can
check who is using the file...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"aramid" <aramid@.hotmail.com> wrote in message news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.
4ax.c
om...
> Hello Everyone,
> We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
> Windows 2003 Ent) from one subnet to another. Everything went well
> (apparently) until we realized that our backups are failing (both the
> existing jobs and manual backups) after the change in ip/subnet was
> done. All backup attempts return with errrors similar to these:
> ===
> 18204 :
> BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
> failed to open. Operating system error = 32(The process cannot access
> the file because it is being used by another process.).
> ===
> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
> TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
> NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
> ===
>
> When the manual backup is initiated without Verification, no (popup)
> error is generated (but the error above is still logged on the event
> log) and the backup says it ran successfully. When the backup file is
> checked, the size is Zero (0) kb.
> There is no apparent problem in connecting to both the two instances
> of the server and applications are working okay, it's just the backup
> problem that is bugging us.
> drive Q = quorum
> drive F = one of the shared drives with 20Gb+ remaining
> The database that we are attempting to backup is just about 11Gb in
> size.
>
> Any help is appreciated.
> Thanks.
>
> Aramid
>
Showing posts with label moving. Show all posts
Showing posts with label moving. Show all posts
Sunday, March 11, 2012
Backup Problem
Hello Everyone,
We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
Windows 2003 Ent) from one subnet to another. Everything went well
(apparently) until we realized that our backups are failing (both the
existing jobs and manual backups) after the change in ip/subnet was
done. All backup attempts return with errrors similar to these:
=== 18204 :
BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
failed to open. Operating system error = 32(The process cannot access
the file because it is being used by another process.).
=== 3041 :
BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
===
When the manual backup is initiated without Verification, no (popup)
error is generated (but the error above is still logged on the event
log) and the backup says it ran successfully. When the backup file is
checked, the size is Zero (0) kb.
There is no apparent problem in connecting to both the two instances
of the server and applications are working okay, it's just the backup
problem that is bugging us.
drive Q = quorum
drive F = one of the shared drives with 20Gb+ remaining
The database that we are attempting to backup is just about 11Gb in
size.
Any help is appreciated.
Thanks.
AramidJust a quick question - were you backing up to a shared network drive
previously? What if you try backing up to the fully qualified UNC Path
instead?
"aramid" <aramid@.hotmail.com> wrote in message
news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.4ax.com...
> Hello Everyone,
> We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
> Windows 2003 Ent) from one subnet to another. Everything went well
> (apparently) until we realized that our backups are failing (both the
> existing jobs and manual backups) after the change in ip/subnet was
> done. All backup attempts return with errrors similar to these:
> ===> 18204 :
> BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
> failed to open. Operating system error = 32(The process cannot access
> the file because it is being used by another process.).
> ===> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
> TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
> NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
> ===>
> When the manual backup is initiated without Verification, no (popup)
> error is generated (but the error above is still logged on the event
> log) and the backup says it ran successfully. When the backup file is
> checked, the size is Zero (0) kb.
> There is no apparent problem in connecting to both the two instances
> of the server and applications are working okay, it's just the backup
> problem that is bugging us.
> drive Q = quorum
> drive F = one of the shared drives with 20Gb+ remaining
> The database that we are attempting to backup is just about 11Gb in
> size.
>
> Any help is appreciated.
> Thanks.
>
> Aramid
>|||Thanks for your reply, Michael.
We are not backing up to any shared network drive, just to this drive,
which is one of the logical drives on an external disk array attached
to the cluster.
Aramid
On Sun, 10 Apr 2005 23:56:13 -0400, "Michael C#" <xyz@.abcdef.com>
wrote:
>Just a quick question - were you backing up to a shared network drive
>previously? What if you try backing up to the fully qualified UNC Path
>instead?
>"aramid" <aramid@.hotmail.com> wrote in message
>news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.4ax.com...
>> Hello Everyone,
>> We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
>> Windows 2003 Ent) from one subnet to another. Everything went well
>> (apparently) until we realized that our backups are failing (both the
>> existing jobs and manual backups) after the change in ip/subnet was
>> done. All backup attempts return with errrors similar to these:
>> ===>> 18204 :
>> BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
>> failed to open. Operating system error = 32(The process cannot access
>> the file because it is being used by another process.).
>> ===>> 3041 :
>> BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
>> TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
>> NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
>> ===>>
>> When the manual backup is initiated without Verification, no (popup)
>> error is generated (but the error above is still logged on the event
>> log) and the backup says it ran successfully. When the backup file is
>> checked, the size is Zero (0) kb.
>> There is no apparent problem in connecting to both the two instances
>> of the server and applications are working okay, it's just the backup
>> problem that is bugging us.
>> drive Q = quorum
>> drive F = one of the shared drives with 20Gb+ remaining
>> The database that we are attempting to backup is just about 11Gb in
>> size.
>>
>> Any help is appreciated.
>> Thanks.
>>
>> Aramid
>>
>|||aramid
It seems that is permission or OS issue . We have recently moved to the
cluster and what i did in the backup script only changed the D:\ Driver
path to N:\ driver path. Run SQL Server Profile to see what is going on.
Have you searched on internet for those errors?
"aramid" <aramid@.hotmail.com> wrote in message
news:0ouj51dm2esqntk6pegt6f37m36f4g8brj@.4ax.com...
> Thanks for your reply, Michael.
> We are not backing up to any shared network drive, just to this drive,
> which is one of the logical drives on an external disk array attached
> to the cluster.
> Aramid
> On Sun, 10 Apr 2005 23:56:13 -0400, "Michael C#" <xyz@.abcdef.com>
> wrote:
> >Just a quick question - were you backing up to a shared network drive
> >previously? What if you try backing up to the fully qualified UNC Path
> >instead?
> >
> >"aramid" <aramid@.hotmail.com> wrote in message
> >news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.4ax.com...
> >> Hello Everyone,
> >>
> >> We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
> >> Windows 2003 Ent) from one subnet to another. Everything went well
> >> (apparently) until we realized that our backups are failing (both the
> >> existing jobs and manual backups) after the change in ip/subnet was
> >> done. All backup attempts return with errrors similar to these:
> >>
> >> ===> >> 18204 :
> >> BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
> >> failed to open. Operating system error = 32(The process cannot access
> >> the file because it is being used by another process.).
> >> ===> >> 3041 :
> >> BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
> >> TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
> >> NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
> >> ===> >>
> >>
> >> When the manual backup is initiated without Verification, no (popup)
> >> error is generated (but the error above is still logged on the event
> >> log) and the backup says it ran successfully. When the backup file is
> >> checked, the size is Zero (0) kb.
> >>
> >> There is no apparent problem in connecting to both the two instances
> >> of the server and applications are working okay, it's just the backup
> >> problem that is bugging us.
> >>
> >> drive Q = quorum
> >> drive F = one of the shared drives with 20Gb+ remaining
> >>
> >> The database that we are attempting to backup is just about 11Gb in
> >> size.
> >>
> >>
> >> Any help is appreciated.
> >>
> >> Thanks.
> >>
> >>
> >> Aramid
> >>
> >>
> >
>|||SQL Server say that the backup file is used by some other process. I'd get a tool with which I can
check who is using the file...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"aramid" <aramid@.hotmail.com> wrote in message news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.4ax.com...
> Hello Everyone,
> We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
> Windows 2003 Ent) from one subnet to another. Everything went well
> (apparently) until we realized that our backups are failing (both the
> existing jobs and manual backups) after the change in ip/subnet was
> done. All backup attempts return with errrors similar to these:
> ===> 18204 :
> BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
> failed to open. Operating system error = 32(The process cannot access
> the file because it is being used by another process.).
> ===> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
> TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
> NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
> ===>
> When the manual backup is initiated without Verification, no (popup)
> error is generated (but the error above is still logged on the event
> log) and the backup says it ran successfully. When the backup file is
> checked, the size is Zero (0) kb.
> There is no apparent problem in connecting to both the two instances
> of the server and applications are working okay, it's just the backup
> problem that is bugging us.
> drive Q = quorum
> drive F = one of the shared drives with 20Gb+ remaining
> The database that we are attempting to backup is just about 11Gb in
> size.
>
> Any help is appreciated.
> Thanks.
>
> Aramid
>
We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
Windows 2003 Ent) from one subnet to another. Everything went well
(apparently) until we realized that our backups are failing (both the
existing jobs and manual backups) after the change in ip/subnet was
done. All backup attempts return with errrors similar to these:
=== 18204 :
BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
failed to open. Operating system error = 32(The process cannot access
the file because it is being used by another process.).
=== 3041 :
BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
===
When the manual backup is initiated without Verification, no (popup)
error is generated (but the error above is still logged on the event
log) and the backup says it ran successfully. When the backup file is
checked, the size is Zero (0) kb.
There is no apparent problem in connecting to both the two instances
of the server and applications are working okay, it's just the backup
problem that is bugging us.
drive Q = quorum
drive F = one of the shared drives with 20Gb+ remaining
The database that we are attempting to backup is just about 11Gb in
size.
Any help is appreciated.
Thanks.
AramidJust a quick question - were you backing up to a shared network drive
previously? What if you try backing up to the fully qualified UNC Path
instead?
"aramid" <aramid@.hotmail.com> wrote in message
news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.4ax.com...
> Hello Everyone,
> We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
> Windows 2003 Ent) from one subnet to another. Everything went well
> (apparently) until we realized that our backups are failing (both the
> existing jobs and manual backups) after the change in ip/subnet was
> done. All backup attempts return with errrors similar to these:
> ===> 18204 :
> BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
> failed to open. Operating system error = 32(The process cannot access
> the file because it is being used by another process.).
> ===> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
> TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
> NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
> ===>
> When the manual backup is initiated without Verification, no (popup)
> error is generated (but the error above is still logged on the event
> log) and the backup says it ran successfully. When the backup file is
> checked, the size is Zero (0) kb.
> There is no apparent problem in connecting to both the two instances
> of the server and applications are working okay, it's just the backup
> problem that is bugging us.
> drive Q = quorum
> drive F = one of the shared drives with 20Gb+ remaining
> The database that we are attempting to backup is just about 11Gb in
> size.
>
> Any help is appreciated.
> Thanks.
>
> Aramid
>|||Thanks for your reply, Michael.
We are not backing up to any shared network drive, just to this drive,
which is one of the logical drives on an external disk array attached
to the cluster.
Aramid
On Sun, 10 Apr 2005 23:56:13 -0400, "Michael C#" <xyz@.abcdef.com>
wrote:
>Just a quick question - were you backing up to a shared network drive
>previously? What if you try backing up to the fully qualified UNC Path
>instead?
>"aramid" <aramid@.hotmail.com> wrote in message
>news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.4ax.com...
>> Hello Everyone,
>> We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
>> Windows 2003 Ent) from one subnet to another. Everything went well
>> (apparently) until we realized that our backups are failing (both the
>> existing jobs and manual backups) after the change in ip/subnet was
>> done. All backup attempts return with errrors similar to these:
>> ===>> 18204 :
>> BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
>> failed to open. Operating system error = 32(The process cannot access
>> the file because it is being used by another process.).
>> ===>> 3041 :
>> BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
>> TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
>> NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
>> ===>>
>> When the manual backup is initiated without Verification, no (popup)
>> error is generated (but the error above is still logged on the event
>> log) and the backup says it ran successfully. When the backup file is
>> checked, the size is Zero (0) kb.
>> There is no apparent problem in connecting to both the two instances
>> of the server and applications are working okay, it's just the backup
>> problem that is bugging us.
>> drive Q = quorum
>> drive F = one of the shared drives with 20Gb+ remaining
>> The database that we are attempting to backup is just about 11Gb in
>> size.
>>
>> Any help is appreciated.
>> Thanks.
>>
>> Aramid
>>
>|||aramid
It seems that is permission or OS issue . We have recently moved to the
cluster and what i did in the backup script only changed the D:\ Driver
path to N:\ driver path. Run SQL Server Profile to see what is going on.
Have you searched on internet for those errors?
"aramid" <aramid@.hotmail.com> wrote in message
news:0ouj51dm2esqntk6pegt6f37m36f4g8brj@.4ax.com...
> Thanks for your reply, Michael.
> We are not backing up to any shared network drive, just to this drive,
> which is one of the logical drives on an external disk array attached
> to the cluster.
> Aramid
> On Sun, 10 Apr 2005 23:56:13 -0400, "Michael C#" <xyz@.abcdef.com>
> wrote:
> >Just a quick question - were you backing up to a shared network drive
> >previously? What if you try backing up to the fully qualified UNC Path
> >instead?
> >
> >"aramid" <aramid@.hotmail.com> wrote in message
> >news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.4ax.com...
> >> Hello Everyone,
> >>
> >> We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
> >> Windows 2003 Ent) from one subnet to another. Everything went well
> >> (apparently) until we realized that our backups are failing (both the
> >> existing jobs and manual backups) after the change in ip/subnet was
> >> done. All backup attempts return with errrors similar to these:
> >>
> >> ===> >> 18204 :
> >> BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
> >> failed to open. Operating system error = 32(The process cannot access
> >> the file because it is being used by another process.).
> >> ===> >> 3041 :
> >> BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
> >> TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
> >> NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
> >> ===> >>
> >>
> >> When the manual backup is initiated without Verification, no (popup)
> >> error is generated (but the error above is still logged on the event
> >> log) and the backup says it ran successfully. When the backup file is
> >> checked, the size is Zero (0) kb.
> >>
> >> There is no apparent problem in connecting to both the two instances
> >> of the server and applications are working okay, it's just the backup
> >> problem that is bugging us.
> >>
> >> drive Q = quorum
> >> drive F = one of the shared drives with 20Gb+ remaining
> >>
> >> The database that we are attempting to backup is just about 11Gb in
> >> size.
> >>
> >>
> >> Any help is appreciated.
> >>
> >> Thanks.
> >>
> >>
> >> Aramid
> >>
> >>
> >
>|||SQL Server say that the backup file is used by some other process. I'd get a tool with which I can
check who is using the file...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"aramid" <aramid@.hotmail.com> wrote in message news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.4ax.com...
> Hello Everyone,
> We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
> Windows 2003 Ent) from one subnet to another. Everything went well
> (apparently) until we realized that our backups are failing (both the
> existing jobs and manual backups) after the change in ip/subnet was
> done. All backup attempts return with errrors similar to these:
> ===> 18204 :
> BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
> failed to open. Operating system error = 32(The process cannot access
> the file because it is being used by another process.).
> ===> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
> TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
> NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
> ===>
> When the manual backup is initiated without Verification, no (popup)
> error is generated (but the error above is still logged on the event
> log) and the backup says it ran successfully. When the backup file is
> checked, the size is Zero (0) kb.
> There is no apparent problem in connecting to both the two instances
> of the server and applications are working okay, it's just the backup
> problem that is bugging us.
> drive Q = quorum
> drive F = one of the shared drives with 20Gb+ remaining
> The database that we are attempting to backup is just about 11Gb in
> size.
>
> Any help is appreciated.
> Thanks.
>
> Aramid
>
Backup Problem
Hello Everyone,
We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
Windows 2003 Ent) from one subnet to another. Everything went well
(apparently) until we realized that our backups are failing (both the
existing jobs and manual backups) after the change in ip/subnet was
done. All backup attempts return with errrors similar to these:
===
18204 :
BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
failed to open. Operating system error = 32(The process cannot access
the file because it is being used by another process.).
===
3041 :
BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
===
When the manual backup is initiated without Verification, no (popup)
error is generated (but the error above is still logged on the event
log) and the backup says it ran successfully. When the backup file is
checked, the size is Zero (0) kb.
There is no apparent problem in connecting to both the two instances
of the server and applications are working okay, it's just the backup
problem that is bugging us.
drive Q = quorum
drive F = one of the shared drives with 20Gb+ remaining
The database that we are attempting to backup is just about 11Gb in
size.
Any help is appreciated.
Thanks.
Aramid
Just a quick question - were you backing up to a shared network drive
previously? What if you try backing up to the fully qualified UNC Path
instead?
"aramid" <aramid@.hotmail.com> wrote in message
news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.4ax.com...
> Hello Everyone,
> We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
> Windows 2003 Ent) from one subnet to another. Everything went well
> (apparently) until we realized that our backups are failing (both the
> existing jobs and manual backups) after the change in ip/subnet was
> done. All backup attempts return with errrors similar to these:
> ===
> 18204 :
> BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
> failed to open. Operating system error = 32(The process cannot access
> the file because it is being used by another process.).
> ===
> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
> TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
> NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
> ===
>
> When the manual backup is initiated without Verification, no (popup)
> error is generated (but the error above is still logged on the event
> log) and the backup says it ran successfully. When the backup file is
> checked, the size is Zero (0) kb.
> There is no apparent problem in connecting to both the two instances
> of the server and applications are working okay, it's just the backup
> problem that is bugging us.
> drive Q = quorum
> drive F = one of the shared drives with 20Gb+ remaining
> The database that we are attempting to backup is just about 11Gb in
> size.
>
> Any help is appreciated.
> Thanks.
>
> Aramid
>
|||Thanks for your reply, Michael.
We are not backing up to any shared network drive, just to this drive,
which is one of the logical drives on an external disk array attached
to the cluster.
Aramid
On Sun, 10 Apr 2005 23:56:13 -0400, "Michael C#" <xyz@.abcdef.com>
wrote:
>Just a quick question - were you backing up to a shared network drive
>previously? What if you try backing up to the fully qualified UNC Path
>instead?
>"aramid" <aramid@.hotmail.com> wrote in message
>news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.4ax.com.. .
>
|||aramid
It seems that is permission or OS issue . We have recently moved to the
cluster and what i did in the backup script only changed the D:\ Driver
path to N:\ driver path. Run SQL Server Profile to see what is going on.
Have you searched on internet for those errors?
"aramid" <aramid@.hotmail.com> wrote in message
news:0ouj51dm2esqntk6pegt6f37m36f4g8brj@.4ax.com...
> Thanks for your reply, Michael.
> We are not backing up to any shared network drive, just to this drive,
> which is one of the logical drives on an external disk array attached
> to the cluster.
> Aramid
> On Sun, 10 Apr 2005 23:56:13 -0400, "Michael C#" <xyz@.abcdef.com>
> wrote:
>
|||SQL Server say that the backup file is used by some other process. I'd get a tool with which I can
check who is using the file...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"aramid" <aramid@.hotmail.com> wrote in message news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.4ax.com...
> Hello Everyone,
> We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
> Windows 2003 Ent) from one subnet to another. Everything went well
> (apparently) until we realized that our backups are failing (both the
> existing jobs and manual backups) after the change in ip/subnet was
> done. All backup attempts return with errrors similar to these:
> ===
> 18204 :
> BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
> failed to open. Operating system error = 32(The process cannot access
> the file because it is being used by another process.).
> ===
> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
> TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
> NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
> ===
>
> When the manual backup is initiated without Verification, no (popup)
> error is generated (but the error above is still logged on the event
> log) and the backup says it ran successfully. When the backup file is
> checked, the size is Zero (0) kb.
> There is no apparent problem in connecting to both the two instances
> of the server and applications are working okay, it's just the backup
> problem that is bugging us.
> drive Q = quorum
> drive F = one of the shared drives with 20Gb+ remaining
> The database that we are attempting to backup is just about 11Gb in
> size.
>
> Any help is appreciated.
> Thanks.
>
> Aramid
>
We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
Windows 2003 Ent) from one subnet to another. Everything went well
(apparently) until we realized that our backups are failing (both the
existing jobs and manual backups) after the change in ip/subnet was
done. All backup attempts return with errrors similar to these:
===
18204 :
BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
failed to open. Operating system error = 32(The process cannot access
the file because it is being used by another process.).
===
3041 :
BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
===
When the manual backup is initiated without Verification, no (popup)
error is generated (but the error above is still logged on the event
log) and the backup says it ran successfully. When the backup file is
checked, the size is Zero (0) kb.
There is no apparent problem in connecting to both the two instances
of the server and applications are working okay, it's just the backup
problem that is bugging us.
drive Q = quorum
drive F = one of the shared drives with 20Gb+ remaining
The database that we are attempting to backup is just about 11Gb in
size.
Any help is appreciated.
Thanks.
Aramid
Just a quick question - were you backing up to a shared network drive
previously? What if you try backing up to the fully qualified UNC Path
instead?
"aramid" <aramid@.hotmail.com> wrote in message
news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.4ax.com...
> Hello Everyone,
> We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
> Windows 2003 Ent) from one subnet to another. Everything went well
> (apparently) until we realized that our backups are failing (both the
> existing jobs and manual backups) after the change in ip/subnet was
> done. All backup attempts return with errrors similar to these:
> ===
> 18204 :
> BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
> failed to open. Operating system error = 32(The process cannot access
> the file because it is being used by another process.).
> ===
> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
> TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
> NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
> ===
>
> When the manual backup is initiated without Verification, no (popup)
> error is generated (but the error above is still logged on the event
> log) and the backup says it ran successfully. When the backup file is
> checked, the size is Zero (0) kb.
> There is no apparent problem in connecting to both the two instances
> of the server and applications are working okay, it's just the backup
> problem that is bugging us.
> drive Q = quorum
> drive F = one of the shared drives with 20Gb+ remaining
> The database that we are attempting to backup is just about 11Gb in
> size.
>
> Any help is appreciated.
> Thanks.
>
> Aramid
>
|||Thanks for your reply, Michael.
We are not backing up to any shared network drive, just to this drive,
which is one of the logical drives on an external disk array attached
to the cluster.
Aramid
On Sun, 10 Apr 2005 23:56:13 -0400, "Michael C#" <xyz@.abcdef.com>
wrote:
>Just a quick question - were you backing up to a shared network drive
>previously? What if you try backing up to the fully qualified UNC Path
>instead?
>"aramid" <aramid@.hotmail.com> wrote in message
>news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.4ax.com.. .
>
|||aramid
It seems that is permission or OS issue . We have recently moved to the
cluster and what i did in the backup script only changed the D:\ Driver
path to N:\ driver path. Run SQL Server Profile to see what is going on.
Have you searched on internet for those errors?
"aramid" <aramid@.hotmail.com> wrote in message
news:0ouj51dm2esqntk6pegt6f37m36f4g8brj@.4ax.com...
> Thanks for your reply, Michael.
> We are not backing up to any shared network drive, just to this drive,
> which is one of the logical drives on an external disk array attached
> to the cluster.
> Aramid
> On Sun, 10 Apr 2005 23:56:13 -0400, "Michael C#" <xyz@.abcdef.com>
> wrote:
>
|||SQL Server say that the backup file is used by some other process. I'd get a tool with which I can
check who is using the file...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"aramid" <aramid@.hotmail.com> wrote in message news:s4rj511nm4jrf8at18grbsnio4jseoc7t8@.4ax.com...
> Hello Everyone,
> We were moving a 2-node DB cluster (Active/Active on SQL 2000 Ent /
> Windows 2003 Ent) from one subnet to another. Everything went well
> (apparently) until we realized that our backups are failing (both the
> existing jobs and manual backups) after the change in ip/subnet was
> done. All backup attempts return with errrors similar to these:
> ===
> 18204 :
> BackupDiskFile::OpenMedia: Backup device 'F:\temp\database_abc_041005'
> failed to open. Operating system error = 32(The process cannot access
> the file because it is being used by another process.).
> ===
> 3041 :
> BACKUP failed to complete the command BACKUP DATABASE [database_abcr]
> TO DISK = N'F:\temp\database_abc_041005' WITH NOINIT , NOUNLOAD ,
> NAME = N'database_abc backup', NOSKIP , STATS = 10, NOFORMAT
> ===
>
> When the manual backup is initiated without Verification, no (popup)
> error is generated (but the error above is still logged on the event
> log) and the backup says it ran successfully. When the backup file is
> checked, the size is Zero (0) kb.
> There is no apparent problem in connecting to both the two instances
> of the server and applications are working okay, it's just the backup
> problem that is bugging us.
> drive Q = quorum
> drive F = one of the shared drives with 20Gb+ remaining
> The database that we are attempting to backup is just about 11Gb in
> size.
>
> Any help is appreciated.
> Thanks.
>
> Aramid
>
Wednesday, March 7, 2012
backup of transaction log
Hello all,
Disaster recovery scenario ques: I am taking full backups of my SQL Server database each midnight on tape and moving it off-site. I then take differential backups and also want to backup the transaction log. Assuming that my production database server is
on site and the site is burned down, how do I recover my transaction logs from? Do companies usually move transaction logs off-site as well?
Where are transaction logs generally stored to facilitate in disaster recovery? Thanks in advance for the help!
- Bill
Hi,
Normally you have to setup a disaster location away from your production
server location. In our case we have got the Disaster recovery server 1000
Miles from our production server. We have set a Logshipping betwen the
production server and Disater recovery server.
How to setup the DR server:-
1. Install the DR server with same Hardware configuration / OS and Patches /
SQL server edition and service packs
2. COnfigure a database identical to production
3. Make the database Readonly
4. Take a Full database backup from production and load it in Disaster
server
5. After that you can perform the transaction log backup, copy to DR server
and load it in DR server. You can fix the interval based on ur data growth
(Preferably 30 minutes)
6. This will ensure that in UR DR side data is available.
NOte:
1. SQL 2000 Enterprise edition has the Logshipping automated feature
http://www.microsoft.com/technet/pro.../logship1.mspx
2. You can Transactional replication also for this to set the Stand by
server.
Thanks
Hari
MCDBA
In SQL 2000 Enterprise edition you have got a
"Bill" <anonymous@.discussions.microsoft.com> wrote in message
news:C53B9957-8D1D-44CC-8023-EACF730AC1EB@.microsoft.com...
> Hello all,
> Disaster recovery scenario ques: I am taking full backups of my SQL Server
database each midnight on tape and moving it off-site. I then take
differential backups and also want to backup the transaction log. Assuming
that my production database server is on site and the site is burned down,
how do I recover my transaction logs from? Do companies usually move
transaction logs off-site as well?
> Where are transaction logs generally stored to facilitate in disaster
recovery? Thanks in advance for the help!
> - Bill
|||HI
Create Disaster recovery Plan
Create job for disaster recovery solution as disaster recovery plan describe.
Step 1.
Backup the database(s) to backup device based on current time and weekday
(Physical file located on file server, this file backed up to tape)
Step 2
Copy backup file(s) to off site server
Step 3 (Optional)
Restore database(s) on off site server
Decrease the backup time:
-Full backup saturday or sunday only, another weekdays create differential backup.
-Create the backup devices:
Use backup devices with INIT (overwrite) option (Tape backups from file server store old versions as need)
DB_Name_full
DB_Name_diff
DB_Name_log1
DB_Name_log2
...
Create Stored Srocedures for Disaster Recovery for all cases.
You can on remote server restore the database manually, or from job (You must create SP-s).
BOL: BACKUP and RESTORE
JBandi
|||Hari and Andras, Thank you for the insights!
-- Hari wrote: --
Hi,
Normally you have to setup a disaster location away from your production
server location. In our case we have got the Disaster recovery server 1000
Miles from our production server. We have set a Logshipping betwen the
production server and Disater recovery server.
How to setup the DR server:-
1. Install the DR server with same Hardware configuration / OS and Patches /
SQL server edition and service packs
2. COnfigure a database identical to production
3. Make the database Readonly
4. Take a Full database backup from production and load it in Disaster
server
5. After that you can perform the transaction log backup, copy to DR server
and load it in DR server. You can fix the interval based on ur data growth
(Preferably 30 minutes)
6. This will ensure that in UR DR side data is available.
NOte:
1. SQL 2000 Enterprise edition has the Logshipping automated feature
http://www.microsoft.com/technet/pro.../logship1.mspx
2. You can Transactional replication also for this to set the Stand by
server.
Thanks
Hari
MCDBA
In SQL 2000 Enterprise edition you have got a
"Bill" <anonymous@.discussions.microsoft.com> wrote in message
news:C53B9957-8D1D-44CC-8023-EACF730AC1EB@.microsoft.com...
> Hello all,
database each midnight on tape and moving it off-site. I then take
differential backups and also want to backup the transaction log. Assuming
that my production database server is on site and the site is burned down,
how do I recover my transaction logs from? Do companies usually move
transaction logs off-site as well?
recovery? Thanks in advance for the help!
> - Bill
Disaster recovery scenario ques: I am taking full backups of my SQL Server database each midnight on tape and moving it off-site. I then take differential backups and also want to backup the transaction log. Assuming that my production database server is
on site and the site is burned down, how do I recover my transaction logs from? Do companies usually move transaction logs off-site as well?
Where are transaction logs generally stored to facilitate in disaster recovery? Thanks in advance for the help!
- Bill
Hi,
Normally you have to setup a disaster location away from your production
server location. In our case we have got the Disaster recovery server 1000
Miles from our production server. We have set a Logshipping betwen the
production server and Disater recovery server.
How to setup the DR server:-
1. Install the DR server with same Hardware configuration / OS and Patches /
SQL server edition and service packs
2. COnfigure a database identical to production
3. Make the database Readonly
4. Take a Full database backup from production and load it in Disaster
server
5. After that you can perform the transaction log backup, copy to DR server
and load it in DR server. You can fix the interval based on ur data growth
(Preferably 30 minutes)
6. This will ensure that in UR DR side data is available.
NOte:
1. SQL 2000 Enterprise edition has the Logshipping automated feature
http://www.microsoft.com/technet/pro.../logship1.mspx
2. You can Transactional replication also for this to set the Stand by
server.
Thanks
Hari
MCDBA
In SQL 2000 Enterprise edition you have got a
"Bill" <anonymous@.discussions.microsoft.com> wrote in message
news:C53B9957-8D1D-44CC-8023-EACF730AC1EB@.microsoft.com...
> Hello all,
> Disaster recovery scenario ques: I am taking full backups of my SQL Server
database each midnight on tape and moving it off-site. I then take
differential backups and also want to backup the transaction log. Assuming
that my production database server is on site and the site is burned down,
how do I recover my transaction logs from? Do companies usually move
transaction logs off-site as well?
> Where are transaction logs generally stored to facilitate in disaster
recovery? Thanks in advance for the help!
> - Bill
|||HI
Create Disaster recovery Plan
Create job for disaster recovery solution as disaster recovery plan describe.
Step 1.
Backup the database(s) to backup device based on current time and weekday
(Physical file located on file server, this file backed up to tape)
Step 2
Copy backup file(s) to off site server
Step 3 (Optional)
Restore database(s) on off site server
Decrease the backup time:
-Full backup saturday or sunday only, another weekdays create differential backup.
-Create the backup devices:
Use backup devices with INIT (overwrite) option (Tape backups from file server store old versions as need)
DB_Name_full
DB_Name_diff
DB_Name_log1
DB_Name_log2
...
Create Stored Srocedures for Disaster Recovery for all cases.
You can on remote server restore the database manually, or from job (You must create SP-s).
BOL: BACKUP and RESTORE
JBandi
|||Hari and Andras, Thank you for the insights!
-- Hari wrote: --
Hi,
Normally you have to setup a disaster location away from your production
server location. In our case we have got the Disaster recovery server 1000
Miles from our production server. We have set a Logshipping betwen the
production server and Disater recovery server.
How to setup the DR server:-
1. Install the DR server with same Hardware configuration / OS and Patches /
SQL server edition and service packs
2. COnfigure a database identical to production
3. Make the database Readonly
4. Take a Full database backup from production and load it in Disaster
server
5. After that you can perform the transaction log backup, copy to DR server
and load it in DR server. You can fix the interval based on ur data growth
(Preferably 30 minutes)
6. This will ensure that in UR DR side data is available.
NOte:
1. SQL 2000 Enterprise edition has the Logshipping automated feature
http://www.microsoft.com/technet/pro.../logship1.mspx
2. You can Transactional replication also for this to set the Stand by
server.
Thanks
Hari
MCDBA
In SQL 2000 Enterprise edition you have got a
"Bill" <anonymous@.discussions.microsoft.com> wrote in message
news:C53B9957-8D1D-44CC-8023-EACF730AC1EB@.microsoft.com...
> Hello all,
database each midnight on tape and moving it off-site. I then take
differential backups and also want to backup the transaction log. Assuming
that my production database server is on site and the site is burned down,
how do I recover my transaction logs from? Do companies usually move
transaction logs off-site as well?
recovery? Thanks in advance for the help!
> - Bill
backup of transaction log
Hello all,
Disaster recovery scenario ques: I am taking full backups of my SQL Server d
atabase each midnight on tape and moving it off-site. I then take differenti
al backups and also want to backup the transaction log. Assuming that my pro
duction database server is
on site and the site is burned down, how do I recover my transaction logs fr
om? Do companies usually move transaction logs off-site as well?
Where are transaction logs generally stored to facilitate in disaster recove
ry? Thanks in advance for the help!
- BillHi,
Normally you have to setup a disaster location away from your production
server location. In our case we have got the Disaster recovery server 1000
Miles from our production server. We have set a Logshipping betwen the
production server and Disater recovery server.
How to setup the DR server:-
1. Install the DR server with same hardware configuration / OS and Patches /
SQL server edition and service packs
2. COnfigure a database identical to production
3. Make the database Readonly
4. Take a Full database backup from production and load it in Disaster
server
5. After that you can perform the transaction log backup, copy to DR server
and load it in DR server. You can fix the interval based on ur data growth
(Preferably 30 minutes)
6. This will ensure that in UR DR side data is available.
NOte:
1. SQL 2000 Enterprise edition has the Logshipping automated feature
http://www.microsoft.com/technet/pr...n/logship1.mspx
2. You can Transactional replication also for this to set the Stand by
server.
Thanks
Hari
MCDBA
In SQL 2000 Enterprise edition you have got a
"Bill" <anonymous@.discussions.microsoft.com> wrote in message
news:C53B9957-8D1D-44CC-8023-EACF730AC1EB@.microsoft.com...
> Hello all,
> Disaster recovery scenario ques: I am taking full backups of my SQL Server
database each midnight on tape and moving it off-site. I then take
differential backups and also want to backup the transaction log. Assuming
that my production database server is on site and the site is burned down,
how do I recover my transaction logs from? Do companies usually move
transaction logs off-site as well?
> Where are transaction logs generally stored to facilitate in disaster
recovery? Thanks in advance for the help!
> - Bill|||HI
Create Disaster recovery Plan
Create job for disaster recovery solution as disaster recovery plan describe
.
Step 1.
Backup the database(s) to backup device based on current time and weekday
(Physical file located on file server, this file backed up to tape)
Step 2
Copy backup file(s) to off site server
Step 3 (Optional)
Restore database(s) on off site server
Decrease the backup time:
-Full backup saturday or sunday only, another weekdays create differential b
ackup.
-Create the backup devices:
Use backup devices with INIT (overwrite) option (Tape backups from file serv
er store old versions as need)
DB_Name_full
DB_Name_diff
DB_Name_log1
DB_Name_log2
...
Create Stored Srocedures for Disaster Recovery for all cases.
You can on remote server restore the database manually, or from job (You mus
t create SP-s).
BOL: BACKUP and RESTORE
JBandi|||Hari and Andras, Thank you for the insights!
-- Hari wrote: --
Hi,
Normally you have to setup a disaster location away from your production
server location. In our case we have got the Disaster recovery server 1000
Miles from our production server. We have set a Logshipping betwen the
production server and Disater recovery server.
How to setup the DR server:-
1. Install the DR server with same hardware configuration / OS and Patches /
SQL server edition and service packs
2. COnfigure a database identical to production
3. Make the database Readonly
4. Take a Full database backup from production and load it in Disaster
server
5. After that you can perform the transaction log backup, copy to DR server
and load it in DR server. You can fix the interval based on ur data growth
(Preferably 30 minutes)
6. This will ensure that in UR DR side data is available.
NOte:
1. SQL 2000 Enterprise edition has the Logshipping automated feature
http://www.microsoft.com/technet/pr...n/logship1.mspx
2. You can Transactional replication also for this to set the Stand by
server.
Thanks
Hari
MCDBA
In SQL 2000 Enterprise edition you have got a
"Bill" <anonymous@.discussions.microsoft.com> wrote in message
news:C53B9957-8D1D-44CC-8023-EACF730AC1EB@.microsoft.com...
> Hello all,
database each midnight on tape and moving it off-site. I then take
differential backups and also want to backup the transaction log. Assuming
that my production database server is on site and the site is burned down,
how do I recover my transaction logs from? Do companies usually move
transaction logs off-site as well?
recovery? Thanks in advance for the help!
> - Bill
Disaster recovery scenario ques: I am taking full backups of my SQL Server d
atabase each midnight on tape and moving it off-site. I then take differenti
al backups and also want to backup the transaction log. Assuming that my pro
duction database server is
on site and the site is burned down, how do I recover my transaction logs fr
om? Do companies usually move transaction logs off-site as well?
Where are transaction logs generally stored to facilitate in disaster recove
ry? Thanks in advance for the help!
- BillHi,
Normally you have to setup a disaster location away from your production
server location. In our case we have got the Disaster recovery server 1000
Miles from our production server. We have set a Logshipping betwen the
production server and Disater recovery server.
How to setup the DR server:-
1. Install the DR server with same hardware configuration / OS and Patches /
SQL server edition and service packs
2. COnfigure a database identical to production
3. Make the database Readonly
4. Take a Full database backup from production and load it in Disaster
server
5. After that you can perform the transaction log backup, copy to DR server
and load it in DR server. You can fix the interval based on ur data growth
(Preferably 30 minutes)
6. This will ensure that in UR DR side data is available.
NOte:
1. SQL 2000 Enterprise edition has the Logshipping automated feature
http://www.microsoft.com/technet/pr...n/logship1.mspx
2. You can Transactional replication also for this to set the Stand by
server.
Thanks
Hari
MCDBA
In SQL 2000 Enterprise edition you have got a
"Bill" <anonymous@.discussions.microsoft.com> wrote in message
news:C53B9957-8D1D-44CC-8023-EACF730AC1EB@.microsoft.com...
> Hello all,
> Disaster recovery scenario ques: I am taking full backups of my SQL Server
database each midnight on tape and moving it off-site. I then take
differential backups and also want to backup the transaction log. Assuming
that my production database server is on site and the site is burned down,
how do I recover my transaction logs from? Do companies usually move
transaction logs off-site as well?
> Where are transaction logs generally stored to facilitate in disaster
recovery? Thanks in advance for the help!
> - Bill|||HI
Create Disaster recovery Plan
Create job for disaster recovery solution as disaster recovery plan describe
.
Step 1.
Backup the database(s) to backup device based on current time and weekday
(Physical file located on file server, this file backed up to tape)
Step 2
Copy backup file(s) to off site server
Step 3 (Optional)
Restore database(s) on off site server
Decrease the backup time:
-Full backup saturday or sunday only, another weekdays create differential b
ackup.
-Create the backup devices:
Use backup devices with INIT (overwrite) option (Tape backups from file serv
er store old versions as need)
DB_Name_full
DB_Name_diff
DB_Name_log1
DB_Name_log2
...
Create Stored Srocedures for Disaster Recovery for all cases.
You can on remote server restore the database manually, or from job (You mus
t create SP-s).
BOL: BACKUP and RESTORE
JBandi|||Hari and Andras, Thank you for the insights!
-- Hari wrote: --
Hi,
Normally you have to setup a disaster location away from your production
server location. In our case we have got the Disaster recovery server 1000
Miles from our production server. We have set a Logshipping betwen the
production server and Disater recovery server.
How to setup the DR server:-
1. Install the DR server with same hardware configuration / OS and Patches /
SQL server edition and service packs
2. COnfigure a database identical to production
3. Make the database Readonly
4. Take a Full database backup from production and load it in Disaster
server
5. After that you can perform the transaction log backup, copy to DR server
and load it in DR server. You can fix the interval based on ur data growth
(Preferably 30 minutes)
6. This will ensure that in UR DR side data is available.
NOte:
1. SQL 2000 Enterprise edition has the Logshipping automated feature
http://www.microsoft.com/technet/pr...n/logship1.mspx
2. You can Transactional replication also for this to set the Stand by
server.
Thanks
Hari
MCDBA
In SQL 2000 Enterprise edition you have got a
"Bill" <anonymous@.discussions.microsoft.com> wrote in message
news:C53B9957-8D1D-44CC-8023-EACF730AC1EB@.microsoft.com...
> Hello all,
database each midnight on tape and moving it off-site. I then take
differential backups and also want to backup the transaction log. Assuming
that my production database server is on site and the site is burned down,
how do I recover my transaction logs from? Do companies usually move
transaction logs off-site as well?
recovery? Thanks in advance for the help!
> - Bill
Subscribe to:
Posts (Atom)