- Peforming a redeploy
- Posted by RikPage on March 20th, 2007
Using the advice given to me earlier, I am in the process of redeploying a
client's environment in my office and have hit my first roadblock.
The Installation and Configuration guide says that I should restore the
database files to
<systemdrive>:\Program Files\Microsoft SQL Server\MSSQL\Data
When I navigate to the specified location I get
<systemdrive>:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
Does this pose a problem for the restore?
The second thing is that I have tried both, dropping in the backups into
both locations (I created the required folders to recreate the pathway) and
when I name the SQL server when running the Redeploy wizard nothing comes up.
Where have I gone wrong?
--
Thank you for the help!!
Richard Page MSc.
- Posted by Merijn van Mourik on March 20th, 2007
Hello,
Did you use the SQL Server Management studio to restore the 2 databases? I
assume you are using SQL Server 2005. (when I look at the path names...)
Best regards,
Merijn van Mourik
"RikPage" wrote:
- Posted by Matt Parks on March 20th, 2007
The physical location of the DB files is not important, what is important is
that SQL knows where to find them. They should be placed though in the same
place as the other DB files on the server (unless you have specific needs
for seperate RAID support, which does not sound likely). Typically though,
most SQL installs will put the DB files on a drive that is different then
the OS.
--
Matt Parks
MVP - Microsoft CRM
"RikPage" <RikPage@discussions.microsoft.com> wrote in message
news:7CA98BAC-DA08-4D00-86CC-B6A7BD501382@microsoft.com...
Using the advice given to me earlier, I am in the process of redeploying a
client's environment in my office and have hit my first roadblock.
The Installation and Configuration guide says that I should restore the
database files to
<systemdrive>:\Program Files\Microsoft SQL Server\MSSQL\Data
When I navigate to the specified location I get
<systemdrive>:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
Does this pose a problem for the restore?
The second thing is that I have tried both, dropping in the backups into
both locations (I created the required folders to recreate the pathway) and
when I name the SQL server when running the Redeploy wizard nothing comes
up.
Where have I gone wrong?
--
Thank you for the help!!
Richard Page MSc.
- Posted by Merijn van Mourik on March 20th, 2007
Im am sorrie Matt, I see our posts are crossing. I will hit the couch now
with a good glass of Belgium beer.... Handing over the newsgroup to another
hemisphere :-)
"Matt Parks" wrote:
