Solved

SQL 2005 Install  can you relocate DB an dlogs at this point?

Posted on 2011-03-02
6
200 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:mhamer
6 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 35016934
>but dont get an option during set up
exactly

>so. can it be done at install
no
0
 

Author Comment

by:mhamer
ID: 35016969
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
0
 

Expert Comment

by:Bonne001
ID: 35016975
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.  
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:mhamer
ID: 35017175
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
0
 
LVL 15

Accepted Solution

by:
derekkromm earned 500 total points
ID: 35017366
No, but one thing you could do to automate it is create a script that has the necessary SQL commands

Then, create a batch file that first runs the sql install, and then, once complete, executes the SQL script you created above against the new server/instance.

That way, you just run the batch file and everything should be setup as desired.
0
 

Author Closing Comment

by:mhamer
ID: 35159806
Thank you
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL HELP 2 87
Sql Data via Excel--performance issues 2 55
Truncate vs Delete 63 105
SQL Server Insert where not exists 24 39
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now