Re: SQL 2005 Embedded and Moving Sharepoint Services Database
- From: "Jonathan Psaila-Depasquale" <nospam@xxxxxxxxxxxxxxx>
- Date: Sun, 19 Aug 2007 19:01:34 +0200
Hi,
Why are you moving the log file off the C drive? If you're moving it
because it has grown too large and you're running out of space then you're
going about things the wrong way. That file will keep growing if you're
running your database in FULL or BULK_LOGGED recovery mode and eventually no
matter where you place it you'll keep running out of space. What you need
to do is to (regularly) run a backup of the log then shrink the file to a
size that make sense for your environment (something that avoids a lot of
growth operations). So if you connect via osql run something as follows:
backup log mydb
to disk = 'c:\mybackuppath\mybackupfile.bak'
go
use mydb
go
dbcc shrinkfile (mylargelogfile, 500)
Jonathan
"Watt, Bobby" <xp1les@xxxxxxx> wrote in message
news:3DE82A96-888E-4307-95F9-23EF23C473DB@xxxxxxxxxxxxxxxx
I have a SQL 2005 Embedded database that was created by SharePoint
Services. It's ldf file has grown to almost 3 gig, and I need to move it
off the C drive. I have successfully moved some of the other databases
using the OSQL command, but when I try to move this one particular database
I keep getting a syntax error. I've checked and rechecked the file name and
I'm typing it in right. It's the Sharepoint_Config database.
SharePoint_Config_0e211848-1a2a-47d8-a407-ec9839afe12b.mdf
The error states Incorrect Syntax near '-'.
Couple of questions.
How can I connect to this database using the SQL 2005 Management Studio?
I'm connecting to CYAN\MICROSOFT##SSEE and using Windows Authentication.
This is the error I get.
Cannot connect to CYAN\MICROSOFT##SSEE.
===================================
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating
Server/Instance Specified) (.Net SqlClient Data Provider)
Any suggestions would be appreciated.
.
- Follow-Ups:
- Re: SQL 2005 Embedded and Moving Sharepoint Services Database
- From: Watt, Bobby
- Re: SQL 2005 Embedded and Moving Sharepoint Services Database
- References:
- SQL 2005 Embedded and Moving Sharepoint Services Database
- From: Watt, Bobby
- SQL 2005 Embedded and Moving Sharepoint Services Database
- Prev by Date: SQL 2005 Embedded and Moving Sharepoint Services Database
- Next by Date: Re: SQL 2005 Embedded and Moving Sharepoint Services Database
- Previous by thread: SQL 2005 Embedded and Moving Sharepoint Services Database
- Next by thread: Re: SQL 2005 Embedded and Moving Sharepoint Services Database
- Index(es):
Relevant Pages
|
