473,810 Members | 3,137 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

change home and data directories

I'm planning to establish a recovery plan for my SQLServer 2000
databases. How to change home and data directories?

Jan 11 '06 #1
3 1276
I'm not sure I understand what you mean by 'home and data directories'.
Usually, a DR recovery step includes either restoring the entire OS onto
identical hardware or reinstalling SQL Server. In the latter case, you can
specify the SQL Server installation and file paths.

You can restore from SQL Server database and transaction log backups to the
location of you choice after the server is prepared.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"hazly" <s_*****@oritec h.com.my> wrote in message
news:11******** *************@z 14g2000cwz.goog legroups.com...
I'm planning to establish a recovery plan for my SQLServer 2000
databases. How to change home and data directories?

Jan 11 '06 #2
The default one can be changed within:

HKLM\Software\m icrosoft\MSSQLS erver\Setup\SQL DataRoot

Is it that what you meant ?

Other location can be obtained here:

http://www.sqldev.net/misc/SQLLocationFunctions.htm

HTH, Jens Suessmeyer.

Jan 11 '06 #3
Thank you for your reply

Jan 12 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
4928
by: Jean-Christian Imbeault | last post by:
I have a user account on a RH Linux machine but no root access. I succesfully installed apache 1.3 under my /home/ account but can't get PHP to install properly. I have done the following steps: #1 compiled and installed apache using --prefix=/home/imbeauje/apache. Tested that it works.
4
12456
by: Luca T. | last post by:
Hello, i need a way to find the home folder of the current user no matter if i am in Linux or Windows for instance: * Linux: /home/username * Windows: C:\Documents and Settings\username Is there any general way to do this?
4
3542
by: Ed | last post by:
Hello All, I posted earlier about a problem I was having with editing or pasting/deleting files in the "Home Directory" of my web server. I just noticed that the "Home Directory" option in the "Home Directory" tab is grayed out. Why would this be grayed out? Would this be a configuration thing or a permissions thing? I have an administrator account on this server
0
1521
by: notalent | last post by:
I'm having a problem with a very basic program. I'm creating a app in Visual Studio (2003) C# to zip up a collection of specified files & directories and save them to a certain location. I have a checkedListBox that holds all the directories and files that I want saved. I have two buttons (One for selecting file & one for directory) that are hooked to a openFileDialog and folderBrowserDialog. When a new file or dir is selected, it...
4
1868
by: Just D. | last post by:
How can we change the property of one subdirectory of the Virtual Directory? One of the directories should be granted "Write". Should we delete this Virtual Directory to recreate it with the required property or there is some way to do that? What I see now is a poor documentation on the Internet about that. Thanks, Just D.
8
1433
by: Jamie | last post by:
Hello Newsgroup: This is my little rant about security and why we have home directories. You may choose to ignore it or disagree with it, that is your perogative and I won't care, but... this little rant needs to be said in the 21'st century, as we seem to have forgotten about it. Many PHP packages and cgi scripts ask you to store database settings and passwords in web space.
4
5789
by: Benjamin Gufler | last post by:
Hi, I'm integrating a database server running Linux and DB2 V9.1 into an LDAP based authentication system. Unfortunately, this will include changing the location of the DB2 instance home directories (it remains the same physical partition, it's just mounted somewhere else) as well as a uid/gid change of the instance owner. Is there any way of performing such a migration except backing up all the databases, dropping and recreating the...
4
1563
by: jmg3000 | last post by:
What's the customary way to keep your own local Python and package directory? For example, when you're on a server where you don't have root access, and everything must go in your home directory. * What directories do you create? * What environment variables do you set? * What config files do you keep? * Does that setup work with distutils and setuptools? What special options do you need to pass to these tools when installing modules...
9
16817
by: frys | last post by:
Access 2003 Windows XP I have a form that is for tracking attendance at programs. the main form is the program information, and the sub form is the attendance information. I have 5 homes and need to switch between each home at any given time. Currently i use a tab form with 5 subforms attached filtering the attendance data for each home. What i wish to do is select a home from a combo/list box and have 1 subform show me the data...
0
9722
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9603
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10644
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
7664
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5550
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5690
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4334
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3863
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3015
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.