Collation Change and SAP Database files path change

[Former Member]

Hi..

I have MS SQL 2005 and EP 7.0 on one server. My question is :

I have <SID>Data, <SID>Log & TEMPDB on one disk and MSSQL.1 on other disk ...

1) Now I want to distribute this files on different disk .. without uninstalling EP or SQL. Please let me know how can i do this.

2) I also want to upgrade from MS SQL Server 2005 SP0 to SP2. How to do this without uninstalling.

3) Also how to change the collation to BIN2 from default.

Points will be awarded to any help.

[Former Member · Accepted solution]

Hi,

1) Now I want to distribute this files on different disk .. without uninstalling EP or SQL. Please let me know how can i do this.

check Note 363018 - File management for SQL Server

2) I also want to upgrade from MS SQL Server 2005 SP0 to SP2. How to do this without uninstalling.

-> first take the complete backup of the database and then apply sql server patch

check Note 985137 - Service Pack Installation for SQL Server 2005

3) Also how to change the collation to BIN2 from default.

SQL server 2005 with EP 7.0 has collation BIN2 , no need to change.

regards,

kaushal

[Former Member · Accepted solution]

But how to change the collation on the SQL Server 2005 which is a standalone server.

[Former Member · Accepted solution]

for collation changing check

http://support.microsoft.com/kb/325335