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