cancel
Showing results for 
Search instead for 
Did you mean: 

EV80SP2 easy (i think) SQL question

GertjanA
Moderator
Moderator
Partner    VIP    Accredited Certified
Hello all,

SQL question for you.

During the install of EV80SP2, I have to enter the database and logfile location for the directory database (as one of the db's)
The database-location I entered correctly (\\servername\g$\mssql10.mssqlserver\sql\data\user01) but I forgot 1 folder in the path for the log-database.

It should be (\\servername\g$\mssql10.mssqlserver\sql\data\log) but I entered (\\servername\g$\mssql10.mssqlserver\sql\log)

How can I move the database from the ..\log to ..\data\log?
It is only the log database, so it should be easy right?

I saw some articles where it was mentioned that because I am staying on the same server, I should be able to stop ev services, detach database, move database, attach database

Can someone please advices?

Thanks

Gertjan
Regards. Gertjan
1 ACCEPTED SOLUTION

Accepted Solutions

Maverik
Level 6
That is right you can do exactly as you say.

View solution in original post

1 REPLY 1

Maverik
Level 6
That is right you can do exactly as you say.