sql backup files: cluster

Showing posts with label cluster. Show all posts

Sunday, March 11, 2012

Backup problem at Cluster (SQL Server 2000)

Hello,
SQL Server 2000 sitting on cluster windows2003. Complete backup to local
disk file, file size was about 4G if sometimes it could be finished
successfuly. Most times (80%) it failed.
Successful complete backup running took less than 4 minutes.
If failed, normally stopped at about 23 seconds.
Tansaction log backup is no problem.
job step:
BACKUP DATABASE [dbname] TO DISK = N'E:\Program Files\Microsoft SQL
Server\MSSQL$SQLC02\BACKUP\dbname.bak' WITH INIT , NOUNLOAD , NAME = N'dbname full backup', NOSKIP , STATS = 10, NOFORMAT
manually run the job get this err:
Executed as user: domainname\user1. ConnectionRead (WrapperRead()).
[SQLSTATE 01000] (Message 258) General network error. Check your network
documentation. [SQLSTATE 08S01] (Error 11) 10 percent backed up. [SQLSTATE
01000] (Error 3211). The step failed.
Database has 1 data file + 1 log file. (I know this is stupid to be having
only one data file, but nothing I can do to it now.)
I really need some directions. This issue is killing me.
Thanks for help!!!!!!!!!!
TomThis is a multi-part message in MIME format.
--010909050504010908020706
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Sorry to ask obvious questions but... How big is your full DB
(sp_helpdb)? About 4GB I assume. How much free disk space do you have
on your E: drive? Does it always fail around the same point (somewhere
between 10% and 20%)? Is E: a local disk, a SAN attached disk or some
network mapped disk?
--
*mike hodgson*
blog: http://sqlnerd.blogspot.com
Tom Runzer wrote:
>Hello,
>SQL Server 2000 sitting on cluster windows2003. Complete backup to local
>disk file, file size was about 4G if sometimes it could be finished
>successfuly. Most times (80%) it failed.
>Successful complete backup running took less than 4 minutes.
>If failed, normally stopped at about 23 seconds.
>Tansaction log backup is no problem.
>job step:
>BACKUP DATABASE [dbname] TO DISK = N'E:\Program Files\Microsoft SQL
>Server\MSSQL$SQLC02\BACKUP\dbname.bak' WITH INIT , NOUNLOAD , NAME =>N'dbname full backup', NOSKIP , STATS = 10, NOFORMAT
>manually run the job get this err:
>Executed as user: domainname\user1. ConnectionRead (WrapperRead()).
>[SQLSTATE 01000] (Message 258) General network error. Check your network
>documentation. [SQLSTATE 08S01] (Error 11) 10 percent backed up. [SQLSTATE
>01000] (Error 3211). The step failed.
>Database has 1 data file + 1 log file. (I know this is stupid to be having
>only one data file, but nothing I can do to it now.)
>I really need some directions. This issue is killing me.
>Thanks for help!!!!!!!!!!
>Tom
>
--010909050504010908020706
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>Sorry to ask obvious questions but...Â How big is your full DB
(sp_helpdb)?Â About 4GB I assume.Â How much free disk space do you have
on your E: drive?Â Does it always fail around the same point (somewhere
between 10% and 20%)?Â Is E: a local disk, a SAN attached disk or some
network mapped disk?</tt> 
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
-- 
 mike
hodgson 
blog: <a
href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a>

</div>
 
 
Tom Runzer wrote:
<blockquote cite="mid43F74958-2081-4A5C-B5F3-55ECDFD62FB8@.microsoft.com"
type="cite">
<pre wrap="">Hello,
SQL Server 2000 sitting on cluster windows2003. Complete backup to local
disk file, file size was about 4G if sometimes it could be finished
successfuly. Most times (80%) it failed.
Successful complete backup running took less than 4 minutes.
If failed, normally stopped at about 23 seconds.
Tansaction log backup is no problem.
job step:
BACKUP DATABASE [dbname] TO DISK = N'E:\Program Files\Microsoft SQL
Server\MSSQL$SQLC02\BACKUP\dbname.bak' WITH INIT , NOUNLOAD , NAME =N'dbname full backup', NOSKIP , STATS = 10, NOFORMAT
manually run the job get this err:
Executed as user: domainname\user1. ConnectionRead (WrapperRead()).
[SQLSTATE 01000] (Message 258) General network error. Check your network
documentation. [SQLSTATE 08S01] (Error 11) 10 percent backed up. [SQLSTATE
01000] (Error 3211). The step failed.
Database has 1 data file + 1 log file. (I know this is stupid to be having
only one data file, but nothing I can do to it now.)
I really need some directions. This issue is killing me.
Thanks for help!!!!!!!!!!
Tom
</pre>
</blockquote>
</body>
</html>
--010909050504010908020706--|||How big is your full DB (sp_helpdb)? About 4GB I assume.
4471 MB
How much free disk space do you have on your E: drive?
55 GB free, also host data file and log file.
Does it always fail around the same point (somewhere > between 10% and 20%)?
yes, after 22 sec, but I couldn't see the percentage, but should be
within 10%
Is E: a local disk, a SAN attached disk or some network mapped disk?
local disk.
Thanks for help!!!!!
"Mike Hodgson" wrote:
> Sorry to ask obvious questions but... How big is your full DB
> (sp_helpdb)? About 4GB I assume. How much free disk space do you have
> on your E: drive? Does it always fail around the same point (somewhere
> between 10% and 20%)? Is E: a local disk, a SAN attached disk or some
> network mapped disk?
> --
> *mike hodgson*
> blog: http://sqlnerd.blogspot.com
>
> Tom Runzer wrote:
> >Hello,
> >
> >SQL Server 2000 sitting on cluster windows2003. Complete backup to local
> >disk file, file size was about 4G if sometimes it could be finished
> >successfuly. Most times (80%) it failed.
> >
> >Successful complete backup running took less than 4 minutes.
> >If failed, normally stopped at about 23 seconds.
> >Tansaction log backup is no problem.
> >
> >job step:
> >BACKUP DATABASE [dbname] TO DISK = N'E:\Program Files\Microsoft SQL
> >Server\MSSQL$SQLC02\BACKUP\dbname.bak' WITH INIT , NOUNLOAD , NAME => >N'dbname full backup', NOSKIP , STATS = 10, NOFORMAT
> >
> >manually run the job get this err:
> >Executed as user: domainname\user1. ConnectionRead (WrapperRead()).
> >[SQLSTATE 01000] (Message 258) General network error. Check your network
> >documentation. [SQLSTATE 08S01] (Error 11) 10 percent backed up. [SQLSTATE
> >01000] (Error 3211). The step failed.
> >
> >Database has 1 data file + 1 log file. (I know this is stupid to be having
> >only one data file, but nothing I can do to it now.)
> >
> >I really need some directions. This issue is killing me.
> >
> >Thanks for help!!!!!!!!!!
> >
> >Tom
> >
> >
>

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
>

Backup Problem

Sunday, February 19, 2012

Backup Maintenance Plan

I am using SQL 2005 std in a cluster configuration.
The problem is running a backup using the maint. plan. I can setup the plan
a schedule the job, however, when the job runs the message I get is
Date 5/12/2006 8:39:01 AM
Log Job History (Maint Plan)
Step ID 1
Server <Server Name>
Job Name Maint Plan
Step Name Subplan
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: <domain name>\sqlsvc. The package execution failed. The
step failed.
I have extended logging turned on but this is the only message I get. I got
this to run once, and that was the first time I setup the plan, I ran it by
right clicking and start job. I have SSIS installed and the SQL agent and
DTC are running.
Thanks for any help.
BrandonDatabase backup errors are logged in the SQL Server Log. Look there for more
information. If the backup was succesfull the information should be there too.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Brandon" wrote:
> I am using SQL 2005 std in a cluster configuration.
> The problem is running a backup using the maint. plan. I can setup the plan
> a schedule the job, however, when the job runs the message I get is
> Date 5/12/2006 8:39:01 AM
> Log Job History (Maint Plan)
> Step ID 1
> Server <Server Name>
> Job Name Maint Plan
> Step Name Subplan
> Duration 00:00:01
> Sql Severity 0
> Sql Message ID 0
> Operator Emailed
> Operator Net sent
> Operator Paged
> Retries Attempted 0
> Message
> Executed as user: <domain name>\sqlsvc. The package execution failed. The
> step failed.
> I have extended logging turned on but this is the only message I get. I got
> this to run once, and that was the first time I setup the plan, I ran it by
> right clicking and start job. I have SSIS installed and the SQL agent and
> DTC are running.
> Thanks for any help.
> Brandon|||I have checked the SQL server log but does not say anything. The only log is
in the job log.
"Ben Nevarez" wrote:
> Database backup errors are logged in the SQL Server Log. Look there for more
> information. If the backup was succesfull the information should be there too.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Brandon" wrote:
> > I am using SQL 2005 std in a cluster configuration.
> >
> > The problem is running a backup using the maint. plan. I can setup the plan
> > a schedule the job, however, when the job runs the message I get is
> >
> > Date 5/12/2006 8:39:01 AM
> > Log Job History (Maint Plan)
> >
> > Step ID 1
> > Server <Server Name>
> > Job Name Maint Plan
> > Step Name Subplan
> > Duration 00:00:01
> > Sql Severity 0
> > Sql Message ID 0
> > Operator Emailed
> > Operator Net sent
> > Operator Paged
> > Retries Attempted 0
> >
> > Message
> > Executed as user: <domain name>\sqlsvc. The package execution failed. The
> > step failed.
> >
> > I have extended logging turned on but this is the only message I get. I got
> > this to run once, and that was the first time I setup the plan, I ran it by
> > right clicking and start job. I have SSIS installed and the SQL agent and
> > DTC are running.
> >
> > Thanks for any help.
> > Brandon|||I found out the issue. You can not create a manitenance plan from a
workstation, you have to be logged into the server and create it there. Even
more if you have a cluster server the active server needs to be the creator.
If you need to edit the plan it also has to be done from the active server.
If you try to edit it from a workstation it will break.
Brandon
"Brandon" wrote:
> I have checked the SQL server log but does not say anything. The only log is
> in the job log.
> "Ben Nevarez" wrote:
> >
> > Database backup errors are logged in the SQL Server Log. Look there for more
> > information. If the backup was succesfull the information should be there too.
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "Brandon" wrote:
> >
> > > I am using SQL 2005 std in a cluster configuration.
> > >
> > > The problem is running a backup using the maint. plan. I can setup the plan
> > > a schedule the job, however, when the job runs the message I get is
> > >
> > > Date 5/12/2006 8:39:01 AM
> > > Log Job History (Maint Plan)
> > >
> > > Step ID 1
> > > Server <Server Name>
> > > Job Name Maint Plan
> > > Step Name Subplan
> > > Duration 00:00:01
> > > Sql Severity 0
> > > Sql Message ID 0
> > > Operator Emailed
> > > Operator Net sent
> > > Operator Paged
> > > Retries Attempted 0
> > >
> > > Message
> > > Executed as user: <domain name>\sqlsvc. The package execution failed. The
> > > step failed.
> > >
> > > I have extended logging turned on but this is the only message I get. I got
> > > this to run once, and that was the first time I setup the plan, I ran it by
> > > right clicking and start job. I have SSIS installed and the SQL agent and
> > > DTC are running.
> > >
> > > Thanks for any help.
> > > Brandon

Sunday, February 12, 2012

backup issue

To all,
As always, I appreciate your help.
In an active/active cluster environment, I have a 68GB
database. Creates a 63GB .BAK file to a separate drive at
night that is on one of the physical nodes of the cluster,
but the physical drive is not assigned to the cluster.
The .BAK is only thing on the drive.
After performing chkdsk maintenance, I got deleting
indexing entry...MFT file. (I think this may be related to
Microsoft's KB327009)
So I've rebooted a couple times performing chkdsk /f and
the disk comes back clean. I backup the db again manually,
doing a restore verify of course, says it's good. At night
when the maintenance job runs, in the morning it says the
file is not a valid backup set. I run chkdsk and get
errors. At night we have a 3rd party backup program that
kicks off and around the same time I have this error in my
system logs: Event ID 12503 - The Distributed Link
Tracking log was corrupt on volume Z: and has been re-
created. This log is used to automatically repair file
links, such as Shell Shortcuts and OLE links, when for
some reason those links become broken.
I have deleted and re-created the job, and this past week.
I've been running the job manually in the evening, the job
will run once successfully at night, but if I allow it to
backup through the jobs the following night. I get that
it's not a valid backup set again. Confusing huh?
Has anyone experienced such a thing? And if so, please
share how you fixed it? If not, any suggestions are
greatly appreciated, because I'm fresh out of ideas.
Thanks,
JosieJosie,
Hello!
Looking at your problem, it appears to me that you could be looking at some
disk corruption. The best place to start would be the Event logs and see
if:-
1. You see any corruption or hardware errors
2. Did the backups actually complete successfully?
3. Is the database corrupt? (Run checkdb)
With SQL Server backups, we usually have commands such as RESTORE
VERIFYONLY and RESTORE HEADERONLY to verify the state of a backup device. A
backup can be deemed as successful only after it's been fully restored, and
a checkdb is run on it.
I'd suggest you look at the event logs, and maybe get your hardware vendors
engaged as well. Have you tried backing up the db to another drive?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

backup issue

To all,
As always, I appreciate your help.
In an active/active cluster environment, I have a 68GB
database. Creates a 63GB .BAK file to a separate drive at
night that is on one of the physical nodes of the cluster,
but the physical drive is not assigned to the cluster.
The .BAK is only thing on the drive.
After performing chkdsk maintenance, I got deleting
indexing entry...MFT file. (I think this may be related to
Microsoft's KB327009)
So I've rebooted a couple times performing chkdsk /f and
the disk comes back clean. I backup the db again manually,
doing a restore verify of course, says it's good. At night
when the maintenance job runs, in the morning it says the
file is not a valid backup set. I run chkdsk and get
errors. At night we have a 3rd party backup program that
kicks off and around the same time I have this error in my
system logs: Event ID 12503 - The Distributed Link
Tracking log was corrupt on volume Z: and has been re-
created. This log is used to automatically repair file
links, such as Shell Shortcuts and OLE links, when for
some reason those links become broken.
I have deleted and re-created the job, and this past week.
I've been running the job manually in the evening, the job
will run once successfully at night, but if I allow it to
backup through the jobs the following night. I get that
it's not a valid backup set again. Confusing huh?
Has anyone experienced such a thing? And if so, please
share how you fixed it? If not, any suggestions are
greatly appreciated, because I'm fresh out of ideas.
Thanks,
Josie
Josie,
Hello!
Looking at your problem, it appears to me that you could be looking at some
disk corruption. The best place to start would be the Event logs and see
if:-
1. You see any corruption or hardware errors
2. Did the backups actually complete successfully?
3. Is the database corrupt? (Run checkdb)
With SQL Server backups, we usually have commands such as RESTORE
VERIFYONLY and RESTORE HEADERONLY to verify the state of a backup device. A
backup can be deemed as successful only after it's been fully restored, and
a checkdb is run on it.
I'd suggest you look at the event logs, and maybe get your hardware vendors
engaged as well. Have you tried backing up the db to another drive?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Sunday, March 11, 2012

Backup problem at Cluster (SQL Server 2000)

Backup problem at Cluster (SQL Server 2000)

Backup problem at Cluster (SQL Server 2000)

Backup Problem

Backup Problem

Backup Problem

Sunday, February 19, 2012

Backup Maintenance Plan

Backup Maintenance Plan

Sunday, February 12, 2012

backup issue

backup issue

backup issue

sql backup files

Blog Archive

About Me