Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Moving SharePoint Database

  Asked By: Erik    Date: Jan 15    Category: Sharepoint    Views: 1029

I just put some more drives into my server and want to move the Transact logs to
them.

I found this article:
njbblog.blogspot.com/.../...move-sql-database.html

Which works fine until you get a - in the file name, i.e. WSS-Content.

It errors out. Any ideas on how to move it?

Share: 

 

1 Answer Found

 
Answer #1    Answered By: Vaasu Radhakrishna     Answered On: Jan 15

I'm guessing it errors  out on the alter database  lines?

Did you try putting single quotes around the name  parameter, like so?


USE master;
GO
ALTER DATABASE 'MOSS_ContentDatabase' MODIFY FILE (NAME =
'MOSS_ContentDatabase', FILENAME =
'D:\MSSQL_Data\MOSS_ContentDatabase.mdf');
GO
ALTER DATABASE 'MOSS_ContentDatabase' MODIFY FILE (NAME =
'MOSS_ContentDatabase_log', FILENAME =
'D:\MSSQL_TLogs\MOSS_ContentDatabase_log.ldf');
GO
ALTER DATABASE 'MOSS_ContentDatabase'
SET ONLINE
GO



 
Didn't find what you were looking for? Find more on Moving SharePoint Database Or get search suggestion and latest updates.




Tagged: