Hi, i am using sharepoint 3.0 and default Embedded Version of SQL express.
Now I would like to change the directory of WSS Content and Search database
(instead of C drive)
When I was using WSS2, I changed it using OSQL command.
For WSS3.0 it is a little different.
Could you help me how to change database directory?
Thanks
That KB article should guide you, through it is for 2.0 > 3.0http://support.microsoft.com/default.aspx/kb/925190
Jens K. Suessmeyer.
http://www.sqlserver2005.de
Hi,
I had SQL Server 2000 installed like below:
Installation Directory = C:\Program Files\Microsoft SQL Server
Default data directory = D:\
Default log directory = D:\
I found out that the data is stored in D:\Program Files\Microsoft SQL Server\MSSQL\data and backup is done in D:\Program Files\Microsoft SQL Server\MSSQL\backup
However, Microsoft says we should never put the ..\backup and ..\data folders in the same partition.
My question is: How can I move the path of the backup directory?
I checked the registy but this is what I found:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
..BackupDirectory=C:\Program Files\Microsoft SQL Server\MSSQL\backup (<-- note it is pointing to C:\ not D:\)
..DefaultData=D:\
Can somebody help please?
http://search.msn.com/results.aspx?q=Introduction+to+Microsoft+SQL+Server%e2%84%a2+2000+Reporting+Services
Beneficial or non-beneficial link above
http://support.microsoft.com/kb/185663/
|||Hi,
As you reach to the correct part change the values of .BackupDirectory=<pathyouwanttoSoreBackUp>
or/and if you are using Schedule/Maintanance Plan you may specify the path their too.
Hemantgiri S. Goswami
Thanks,
EricYou can specify the default database file locations using SQL Server
Management Studio. Right-click the server in the object explorer and select
Properties-->Database Settings.
The SQL 2005 Books Online includes detailed steps on moving database files.
There is a different procedure for system vs. user databases.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Eric Bragas" <ericbragas@.yahoo.comwrote in message
news:1159469015.718736.156300@.d34g2000cwd.googlegr oups.com...
Quote:
Originally Posted by
Hi, I've installed SQL 2005 and failed to change the default data
location during installation. Now I want to change it. Can I do this
without having to uninstall and reinstall? And furthermore, is there a
system stored procedure I can use to move existing data and log files
(master, msdb, AdventureWorks, etc.)? I seem to remember doing just
this with SQL 2000 some time back.
>
Thanks,
Eric
>
-Eric
Can you please tell me how should I change the default root directory (used for db storage) in SQL 2005 Std. Edition. ?
Currently its configured to:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
and I want to change the drive letter here.
Thanks in advance.
Cyk
-- Try this:
declare @.SmoRoot nvarchar(512)
exec master.dbo.xp_instance_regread
'HKEY_LOCAL_MACHINE'
,'SOFTWARE\Microsoft\MSSQLServer\Setup'
,'SQLPath'
,@.SmoRoot OUTPUT
print 'Old root dir: '+ @.SmoRoot
set @.SmoRoot = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL'
exec master.dbo.xp_instance_regwrite
'HKEY_LOCAL_MACHINE'
,'SOFTWARE\Microsoft\MSSQLServer\Setup'
,'SQLPath'
,REG_SZ
,@.SmoRoot
exec master.dbo.xp_instance_regread
'HKEY_LOCAL_MACHINE'
,'SOFTWARE\Microsoft\MSSQLServer\Setup'
,'SQLPath'
,@.SmoRoot OUTPUT
print 'New root dir: '+ @.SmoRoot
-- Bo
sqlCan you please tell me how should I change the default root directory (used for db storage) in SQL 2005 Std. Edition. ?
Currently its configured to:
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
and I want to change the drive letter here.
Thanks in advance.
Cyk
-- Try this:
declare @.SmoRoot nvarchar(512)
exec master.dbo.xp_instance_regread
'HKEY_LOCAL_MACHINE'
,'SOFTWARE\Microsoft\MSSQLServer\Setup'
,'SQLPath'
,@.SmoRoot OUTPUT
print 'Old root dir: '+ @.SmoRoot
set @.SmoRoot = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL'
exec master.dbo.xp_instance_regwrite
'HKEY_LOCAL_MACHINE'
,'SOFTWARE\Microsoft\MSSQLServer\Setup'
,'SQLPath'
,REG_SZ
,@.SmoRoot
exec master.dbo.xp_instance_regread
'HKEY_LOCAL_MACHINE'
,'SOFTWARE\Microsoft\MSSQLServer\Setup'
,'SQLPath'
,@.SmoRoot OUTPUT
print 'New root dir: '+ @.SmoRoot
-- Bo
Thanks,
EricYou can specify the default database file locations using SQL Server
Management Studio. Right-click the server in the object explorer and select
Properties-->Database Settings.
The SQL 2005 Books Online includes detailed steps on moving database files.
There is a different procedure for system vs. user databases.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Eric Bragas" <ericbragas@.yahoo.comwrote in message
news:1159469015.718736.156300@.d34g2000cwd.googlegr oups.com...
Quote:
Originally Posted by
Hi, I've installed SQL 2005 and failed to change the default data
location during installation. Now I want to change it. Can I do this
without having to uninstall and reinstall? And furthermore, is there a
system stored procedure I can use to move existing data and log files
(master, msdb, AdventureWorks, etc.)? I seem to remember doing just
this with SQL 2000 some time back.
>
Thanks,
Eric
>
-Eric
quote:
> Hi everyone,
> I have a problem here. I install SQL Server and set it's Data Folder to C:
> drive.
> Unfortunately my C drive is running out of space and I plan to add another
> drive (D: drive).
> I want to move my database to D: drive, but however I cannot see D: drive
quote:
> the SQL Server Enterprise Manager
> when I try to add a new database.
> Could anyone help me?
> Best Regards,
> Deili.
>
