mhamer
asked on
SQL 2005 Install can you relocate DB an dlogs at this point?
hi, I would like the DB tempdb and logs to go on diffrent drives but dont get an option during set up
we normally use scripts which does all this but the script is way over my head in terms of editing it, it calls external assemblies etc
so. can it be done at install
is there a simple install script out there
or do i have to do it manually after install
cheers
we normally use scripts which does all this but the script is way over my head in terms of editing it, it calls external assemblies etc
so. can it be done at install
is there a simple install script out there
or do i have to do it manually after install
cheers
ASKER
thanks for that.
eg can i set the registry prior then run install
can i add switches to the setup
the script i cant fathom does it all at install, so it can be done im asking how. it may not use the GUI granted
eg can i set the registry prior then run install
can i add switches to the setup
the script i cant fathom does it all at install, so it can be done im asking how. it may not use the GUI granted
I do not understand your question are you moving only the SQL databases or are you relocating the SQL server also?
Try this link: http://support.microsoft.com/kb/224071
We move databases all of the time by doing a backup and restore on different SQL Servers.
Try this link: http://support.microsoft.com/kb/224071
We move databases all of the time by doing a backup and restore on different SQL Servers.
ASKER
im installing a new Sql server
when the time comes i would like the databases that are created to automatically stor ethere Db and logs on diffrent drives.
I know how to do it after the fact, it would be nicer for me on the test rig to have this already done
when the time comes i would like the databases that are created to automatically stor ethere Db and logs on diffrent drives.
I know how to do it after the fact, it would be nicer for me on the test rig to have this already done
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
exactly
>so. can it be done at install
no