Back in June of last year I posted about how our old SharePoint '07 database has grown exorbitantly large. The problem is that C:\ and E:\ are on a single VMDK and the C:\ parition is nearly out of room (only about 6 GB left!). I don't want to try and resize the partitions because I am afraid it will break (what effectively is) our PDC.
I'm also trying SQL query commands from this site (via SQL server mgmt Studio 08), but they also do not work due to lack of permissions.
So now I'm trying to do this: https://webblah.wordpress.com/2009/10/20/how-to-shrink-the-sharepoint-config-database-log-file-on-a-...
...but the file just returns this:
C:\>sqlcmd -S \\.\pipe\mssql$microsoft##ssee\sql\query -E -i c:\logshrink.sql Msg 102, Level 15, State 1, Server OLD-SBS-SERVER\MICROSOFT##SSEE, Line 4 Incorrect syntax near '?'. Msg 102, Level 15, State 1, Server OLD-SBS-SERVER\MICROSOFT##SSEE, Line 5 Incorrect syntax near '?'. Msg 102, Level 15, State 1, Server OLD-SBS-SERVER\MICROSOFT##SSEE, Line 5 Incorrect syntax near 'â'. Msg 102, Level 15, State 1, Server OLD-SBS-SERVER\MICROSOFT##SSEE, Line 7 Incorrect syntax near '?'. Msg 911, Level 16, State 1, Server OLD-SBS-SERVER\MICROSOFT##SSEE, Line 7 Could not locate entry in sysdatabases for database 'â?~ + RTRIM(@COnfigDB) + â? ~'. No entry found with that name. Make sure that the name is entered correctly.
I cannot seem to get the SQLCMD -S . command to work. What can I do here? Thanks.
