backup failure

Question

backup failure

jgflufg

SSCommitted

Points: 1588
More actions
January 18, 2009 at 11:53 pm

#205543

Hi this is cluster server .Inthis backup was failed with the erro
can not open the following files
t;\michrosoftsqlserve\mssql.1\mssql\data
all of the data files of the system dbs and user dbs.
and the backup completed partial successful.
pls tell where i have to check .and how to troubleshoot this.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 1

mohinidba (1/18/2009)
Hi this is cluster server .Inthis backup was failed with the erro
can not open the following files
t;\michrosoftsqlserve\mssql.1\mssql\data
all of the data files of the system dbs and user dbs.
and the backup completed partial successful.
pls tell where i have to check .and how to troubleshoot this.

First thing to do is to make sure the server can actually read and write to that path. I'm thinking that that semi-colon should actuallly be a colon. Second, make sure the server has the correct privs.

Easy way to do that is as follows...

EXEC Master.dbo.xp_Dirtree 't:\michrosoftsqlserve\mssql.1\mssql\data',1,1

If the resultset is empty, there's a pretty good chance that either the server can't see the path or the path is actually empty.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

jgflufg SSCommitted Points: 1588 More actions · Answer 2

I got this result after executing the above command

ubdirectory depth file

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- -----------

(0 row(s) affected)

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 3

Ok... create a dummy text file and put it in that same path and run the xp_Dirtree command again.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

jgflufg SSCommitted Points: 1588 More actions · Answer 4

I got this result

subdirectory depth file

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- -----------

baru.mdf 1 1

baru_log.ldf 1 1

distmdl.ldf 1 1

distmdl.mdf 1 1

master.mdf 1 1

mastlog.ldf 1 1

model.mdf 1 1

modellog.ldf 1 1

mohini.mdf 1 1

mohini_log.ldf 1 1

msdbdata.mdf 1 1

msdblog.ldf 1 1

mssqlsystemresource.ldf 1 1

mssqlsystemresource.mdf 1 1

New Text document.txt 1 1

(15 row(s) affected)

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 5

Ok... something big just changed. It couldn't see the files in that directory before, but suddenly it can. Try running the backup again.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ps. One Orange Chip Points: 29422 More actions · Answer 6

:w00t: Is there a rationale behind this weird behaviour?

Pradeep Singh

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 7

ps (1/20/2009)
:w00t: Is there a rationale behind this weird behaviour?

Heh... WHICH wierd behaviour? :hehe:

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

ps. One Orange Chip Points: 29422 More actions · Answer 8

xp_dirtree wasnt able to see files in the folder and after adding a dummy file, it showed all other files...

:smooooth:

Pradeep Singh

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 9

I'm thinking it was a coincidence... not sure though... looks like one of those times when you "had to be there" to figure it out. I've never seen that behaviour out of xp_Dirtree before.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)