Msg 911, Level 1, State 10, Line 1, Could not locate entry in

The SharePoint_config log file is getting too big, I want to shrink
it. I find some blog and follow the instructions, but when I execute
it, I got the Msg 911, Level 1, State 10, Line 1 error
Here is what I did:
C:\Program Files\Microsoft SQL Server\90\tools\binn > sqlcmd -S \\.
\pipe\mssql$microsoft##ssee\sql\query -E
1> backup log [SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639]
2> to disk = 'd:\sharepoint\config.bak'
3> go
Msg 911, Level 1, State 10, Server JITTERBUG\microsoft##ssee, Line 1
Could not locate entry in sysdatabases for database
'SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639'
No entry found with that name. Make sure that the name is entered
correctly.
Msg 3013, Level 16, State 1, Server JITTERBUG\microsoft##ssee, Line 1
Backup log is terminating abnormally.
Can you help? Thanks.
AaronThe backup command tries to backup a database named
"SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639". Do you have such database? If not, specify
the correct database name for the backup command.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<achan@.rosewater.com> wrote in message
news:3876feb7-df80-4b77-ba38-487da8f57257@.62g2000hsn.googlegroups.com...
> The SharePoint_config log file is getting too big, I want to shrink
> it. I find some blog and follow the instructions, but when I execute
> it, I got the Msg 911, Level 1, State 10, Line 1 error
> Here is what I did:
> C:\Program Files\Microsoft SQL Server\90\tools\binn > sqlcmd -S \\.
> \pipe\mssql$microsoft##ssee\sql\query -E
> 1> backup log [SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639]
> 2> to disk = 'd:\sharepoint\config.bak'
> 3> go
> Msg 911, Level 1, State 10, Server JITTERBUG\microsoft##ssee, Line 1
> Could not locate entry in sysdatabases for database
> 'SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639'
> No entry found with that name. Make sure that the name is entered
> correctly.
> Msg 3013, Level 16, State 1, Server JITTERBUG\microsoft##ssee, Line 1
> Backup log is terminating abnormally.
> Can you help? Thanks.
> Aaron|||Hi
I have never seen the name pipe connection in the server parameter for
SQLCMD but it seems to work!! It would be easier to do something like
np:(local) though!!
The error message says that it can find the database in sysdatabases and
that seems to be the issue.
Try
SELECT Name FROM master..sysdatabases where NAME LIKE 'SharePoint_config%'
to get the name
John
<achan@.rosewater.com> wrote in message
news:3876feb7-df80-4b77-ba38-487da8f57257@.62g2000hsn.googlegroups.com...
> The SharePoint_config log file is getting too big, I want to shrink
> it. I find some blog and follow the instructions, but when I execute
> it, I got the Msg 911, Level 1, State 10, Line 1 error
> Here is what I did:
> C:\Program Files\Microsoft SQL Server\90\tools\binn > sqlcmd -S \\.
> \pipe\mssql$microsoft##ssee\sql\query -E
> 1> backup log [SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639]
> 2> to disk = 'd:\sharepoint\config.bak'
> 3> go
> Msg 911, Level 1, State 10, Server JITTERBUG\microsoft##ssee, Line 1
> Could not locate entry in sysdatabases for database
> 'SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639'
> No entry found with that name. Make sure that the name is entered
> correctly.
> Msg 3013, Level 16, State 1, Server JITTERBUG\microsoft##ssee, Line 1
> Backup log is terminating abnormally.
> Can you help? Thanks.
> Aaron|||I did that and it did display the file name.
"John Bell" wrote:
> Hi
> I have never seen the name pipe connection in the server parameter for
> SQLCMD but it seems to work!! It would be easier to do something like
> np:(local) though!!
> The error message says that it can find the database in sysdatabases and
> that seems to be the issue.
> Try
> SELECT Name FROM master..sysdatabases where NAME LIKE 'SharePoint_config%'
> to get the name
> John
>
> <achan@.rosewater.com> wrote in message
> news:3876feb7-df80-4b77-ba38-487da8f57257@.62g2000hsn.googlegroups.com...
> > The SharePoint_config log file is getting too big, I want to shrink
> > it. I find some blog and follow the instructions, but when I execute
> > it, I got the Msg 911, Level 1, State 10, Line 1 error
> >
> > Here is what I did:
> >
> > C:\Program Files\Microsoft SQL Server\90\tools\binn > sqlcmd -S \\.
> > \pipe\mssql$microsoft##ssee\sql\query -E
> > 1> backup log [SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639]
> > 2> to disk = 'd:\sharepoint\config.bak'
> > 3> go
> > Msg 911, Level 1, State 10, Server JITTERBUG\microsoft##ssee, Line 1
> > Could not locate entry in sysdatabases for database
> > 'SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639'
> > No entry found with that name. Make sure that the name is entered
> > correctly.
> > Msg 3013, Level 16, State 1, Server JITTERBUG\microsoft##ssee, Line 1
> > Backup log is terminating abnormally.
> >
> > Can you help? Thanks.
> >
> > Aaron
>
>|||Yes, I use the select name from sysdatabases and it display the name. I also
look into the c:\windows\sysmsi\ssee\mssql.2005\mssql\data where it reside
and the file name is there.
"Tibor Karaszi" wrote:
> The backup command tries to backup a database named
> "SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639". Do you have such database? If not, specify
> the correct database name for the backup command.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> <achan@.rosewater.com> wrote in message
> news:3876feb7-df80-4b77-ba38-487da8f57257@.62g2000hsn.googlegroups.com...
> > The SharePoint_config log file is getting too big, I want to shrink
> > it. I find some blog and follow the instructions, but when I execute
> > it, I got the Msg 911, Level 1, State 10, Line 1 error
> >
> > Here is what I did:
> >
> > C:\Program Files\Microsoft SQL Server\90\tools\binn > sqlcmd -S \\.
> > \pipe\mssql$microsoft##ssee\sql\query -E
> > 1> backup log [SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639]
> > 2> to disk = 'd:\sharepoint\config.bak'
> > 3> go
> > Msg 911, Level 1, State 10, Server JITTERBUG\microsoft##ssee, Line 1
> > Could not locate entry in sysdatabases for database
> > 'SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639'
> > No entry found with that name. Make sure that the name is entered
> > correctly.
> > Msg 3013, Level 16, State 1, Server JITTERBUG\microsoft##ssee, Line 1
> > Backup log is terminating abnormally.
> >
> > Can you help? Thanks.
> >
> > Aaron
>|||Then There's probably something special with the SQL Server that comes with SharePoint (assuming
that you are 100% positive of the correct database name and that you connected to the correct SQL
Server instance). You might want to try this in a SharePoint group and see if they have some hints.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Aaron" <Aaron@.discussions.microsoft.com> wrote in message
news:AC3CD1A0-A462-4398-A560-84842EB40433@.microsoft.com...
> Yes, I use the select name from sysdatabases and it display the name. I also
> look into the c:\windows\sysmsi\ssee\mssql.2005\mssql\data where it reside
> and the file name is there.
> "Tibor Karaszi" wrote:
>> The backup command tries to backup a database named
>> "SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639". Do you have such database? If not,
>> specify
>> the correct database name for the backup command.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> <achan@.rosewater.com> wrote in message
>> news:3876feb7-df80-4b77-ba38-487da8f57257@.62g2000hsn.googlegroups.com...
>> > The SharePoint_config log file is getting too big, I want to shrink
>> > it. I find some blog and follow the instructions, but when I execute
>> > it, I got the Msg 911, Level 1, State 10, Line 1 error
>> >
>> > Here is what I did:
>> >
>> > C:\Program Files\Microsoft SQL Server\90\tools\binn > sqlcmd -S \\.
>> > \pipe\mssql$microsoft##ssee\sql\query -E
>> > 1> backup log [SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639]
>> > 2> to disk = 'd:\sharepoint\config.bak'
>> > 3> go
>> > Msg 911, Level 1, State 10, Server JITTERBUG\microsoft##ssee, Line 1
>> > Could not locate entry in sysdatabases for database
>> > 'SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639'
>> > No entry found with that name. Make sure that the name is entered
>> > correctly.
>> > Msg 3013, Level 16, State 1, Server JITTERBUG\microsoft##ssee, Line 1
>> > Backup log is terminating abnormally.
>> >
>> > Can you help? Thanks.
>> >
>> > Aaron
>>|||Thanks Tibor.
"Tibor Karaszi" wrote:
> Then There's probably something special with the SQL Server that comes with SharePoint (assuming
> that you are 100% positive of the correct database name and that you connected to the correct SQL
> Server instance). You might want to try this in a SharePoint group and see if they have some hints.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Aaron" <Aaron@.discussions.microsoft.com> wrote in message
> news:AC3CD1A0-A462-4398-A560-84842EB40433@.microsoft.com...
> > Yes, I use the select name from sysdatabases and it display the name. I also
> > look into the c:\windows\sysmsi\ssee\mssql.2005\mssql\data where it reside
> > and the file name is there.
> >
> > "Tibor Karaszi" wrote:
> >
> >> The backup command tries to backup a database named
> >> "SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639". Do you have such database? If not,
> >> specify
> >> the correct database name for the backup command.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://sqlblog.com/blogs/tibor_karaszi
> >>
> >>
> >> <achan@.rosewater.com> wrote in message
> >> news:3876feb7-df80-4b77-ba38-487da8f57257@.62g2000hsn.googlegroups.com...
> >> > The SharePoint_config log file is getting too big, I want to shrink
> >> > it. I find some blog and follow the instructions, but when I execute
> >> > it, I got the Msg 911, Level 1, State 10, Line 1 error
> >> >
> >> > Here is what I did:
> >> >
> >> > C:\Program Files\Microsoft SQL Server\90\tools\binn > sqlcmd -S \\.
> >> > \pipe\mssql$microsoft##ssee\sql\query -E
> >> > 1> backup log [SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639]
> >> > 2> to disk = 'd:\sharepoint\config.bak'
> >> > 3> go
> >> > Msg 911, Level 1, State 10, Server JITTERBUG\microsoft##ssee, Line 1
> >> > Could not locate entry in sysdatabases for database
> >> > 'SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639'
> >> > No entry found with that name. Make sure that the name is entered
> >> > correctly.
> >> > Msg 3013, Level 16, State 1, Server JITTERBUG\microsoft##ssee, Line 1
> >> > Backup log is terminating abnormally.
> >> >
> >> > Can you help? Thanks.
> >> >
> >> > Aaron
> >>
> >>
>|||Hi
In which case try
SELECT 'backup log [' + name + '] to disk = ''d:\sharepoint\config.bak''
FROM master..sysdatabases where NAME LIKE 'SharePoint_config%'
And the run the command generated in the output.
John
"Aaron" <Aaron@.discussions.microsoft.com> wrote in message
news:005608A7-6260-4D19-BF44-A09A87E4CD90@.microsoft.com...
>I did that and it did display the file name.
> "John Bell" wrote:
>> Hi
>> I have never seen the name pipe connection in the server parameter for
>> SQLCMD but it seems to work!! It would be easier to do something like
>> np:(local) though!!
>> The error message says that it can find the database in sysdatabases and
>> that seems to be the issue.
>> Try
>> SELECT Name FROM master..sysdatabases where NAME LIKE
>> 'SharePoint_config%'
>> to get the name
>> John
>>
>> <achan@.rosewater.com> wrote in message
>> news:3876feb7-df80-4b77-ba38-487da8f57257@.62g2000hsn.googlegroups.com...
>> > The SharePoint_config log file is getting too big, I want to shrink
>> > it. I find some blog and follow the instructions, but when I execute
>> > it, I got the Msg 911, Level 1, State 10, Line 1 error
>> >
>> > Here is what I did:
>> >
>> > C:\Program Files\Microsoft SQL Server\90\tools\binn > sqlcmd -S \\.
>> > \pipe\mssql$microsoft##ssee\sql\query -E
>> > 1> backup log [SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639]
>> > 2> to disk = 'd:\sharepoint\config.bak'
>> > 3> go
>> > Msg 911, Level 1, State 10, Server JITTERBUG\microsoft##ssee, Line 1
>> > Could not locate entry in sysdatabases for database
>> > 'SharePoint_Config_5eb4c0dd-5315-4e4e-8969-10a020979639'
>> > No entry found with that name. Make sure that the name is entered
>> > correctly.
>> > Msg 3013, Level 16, State 1, Server JITTERBUG\microsoft##ssee, Line 1
>> > Backup log is terminating abnormally.
>> >
>> > Can you help? Thanks.
>> >
>> > Aaron
>>