Thanks Gail and David,

Ok i understand your point,however i have to relay this properly to my supervisor.

Possible solution:

1. is to have additional GB of backup disk. or since we have...

Hi Gail,

we aim to free some space in our backup drive. again i didn't come out with this script and the task was given to me to find solution to...

Hi David,

can you check this script in replacement for the previous script.. i have read this in other forum and i guess it works for them...

BACKUP LOG DBNAME WITH NO_LOG

GO

USE...

to make it easy for you to understand what i am trying to do.

we have this script in batch file to run in BackupAssist program. (the script should work in...

Hi Chandu,

How to check/know the file ID. is it the same as SPID? i do have the same error..please help.

thanks

anthony

Hi David, i have included the database name in the -S parameters, here's the new error...what should i consider next?

Msg 8985, Level 16, State 1, Server computername\ABCCOMPANYSQLSERVER, Line 1

Could not...

Thanks David.

I've checked the Named Pipes and is ENABLED.

Want to make sure for this > Server Name = Computer Name?

And, you said - I need to have the DBA? how...

yes. i forgot to specify the location of the filename..i can call the dbcc.bat now with output.txt. this one WORKS OK NOW!!!!

but i still get the error below even if...

Hi,

i received this error message.

sqlcmd :'dbcc.bat': Invalid filename

thanks

thanks David,

correct me if i'm wrong. I have a batch file dbcc.bat (will .bat ok? as prerequisite to call in our third party software) with the DBCC script mentioned above...

I have tried the link you provided earlier and installed the package but can get the sqlcmd running.

anyway thanks for your help.

Hi David,

thanks for the feedback.

i do have a question for you, you said that I need to execute the DBCC command like i am executing sql through a connection to...

Thanks Gail,

again sorry for the ignorance. HOw should my script execute that query? Given the script.. how should my make it run in DOS command as we need this script...

i am a sql newbie. i will appreciate if you can provide more details in your reply.

thanks david.