Moving SQL 2005 Express Databases

As part of the installtion for my Blackberry Professional Software SQL 2005
Express was installed. Unfortuantly during the install I was only able to
specify where the databases for the blackberry server were placed. The rest
of the SQL 2005 Express databases were placed on C. Is there a way to move
them to my F drive were my Blackberry databse is stored.
George,
http://technet.microsoft.com/en-us/library/ms189133.aspx This page is a
link to two pages, one for user databases and one for system databases.
That should give you a cookbook to follow.
RLF
"George Schneider" <georgedschneider@.noemail.noemail> wrote in message
news:A002691D-AE4C-44C6-A0E8-EB5D0EC0E8DE@.microsoft.com...
> As part of the installtion for my Blackberry Professional Software SQL
> 2005
> Express was installed. Unfortuantly during the install I was only able to
> specify where the databases for the blackberry server were placed. The
> rest
> of the SQL 2005 Express databases were placed on C. Is there a way to
> move
> them to my F drive were my Blackberry databse is stored.
|||I get a page could not be found or has been moved page.
"Russell Fields" wrote:

> George,
> http://technet.microsoft.com/en-us/library/ms189133.aspx This page is a
> link to two pages, one for user databases and one for system databases.
> That should give you a cookbook to follow.
> RLF
>
> "George Schneider" <georgedschneider@.noemail.noemail> wrote in message
> news:A002691D-AE4C-44C6-A0E8-EB5D0EC0E8DE@.microsoft.com...
>
>
|||Dear George,
Thank you for posting here.
The link (http://technet.microsoft.com/en-us/library/ms189133.aspx) shared
by RLF is valid. So, would you please test the again. In addition, I also
would like to share with you the following KB article which also describes
the detail information on how to change the location of the data files and
of the log files for any Microsoft SQL Server 2005, SQL Server 2000, or SQL
Server 7.0 database.
How to move SQL Server databases to a new location by using Detach and
Attach functions in SQL Server
http://support.microsoft.com/kb/224071
Hope above information is helpful.
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Thread-Topic: Moving SQL 2005 Express Databases
| thread-index: AchDaVKMcP7akeYMS+G8kuyf2UPqAQ==
| X-WBNR-Posting-Host: 207.46.192.207
| From: =?Utf-8?B?R2VvcmdlIFNjaG5laWRlcg==?=
<georgedschneider@.noemail.noemail>
| References: <A002691D-AE4C-44C6-A0E8-EB5D0EC0E8DE@.microsoft.com>
<e99T0C1QIHA.4880@.TK2MSFTNGP03.phx.gbl>
| Subject: Re: Moving SQL 2005 Express Databases
| Date: Thu, 20 Dec 2007 16:35:01 -0800
| Lines: 26
| Message-ID: <880D702B-D832-4405-9545-783FD1A79D87@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
| Newsgroups: microsoft.public.sqlserver.msde
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.msde:841
| NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
| X-Tomcat-NG: microsoft.public.sqlserver.msde
|
| I get a page could not be found or has been moved page.
|
| "Russell Fields" wrote:
|
| > George,
| >
| > http://technet.microsoft.com/en-us/library/ms189133.aspx This page is
a
| > link to two pages, one for user databases and one for system databases.
| > That should give you a cookbook to follow.
| >
| > RLF
| >
| >
| > "George Schneider" <georgedschneider@.noemail.noemail> wrote in message
| > news:A002691D-AE4C-44C6-A0E8-EB5D0EC0E8DE@.microsoft.com...
| > > As part of the installtion for my Blackberry Professional Software
SQL
| > > 2005
| > > Express was installed. Unfortuantly during the install I was only
able to
| > > specify where the databases for the blackberry server were placed.
The
| > > rest
| > > of the SQL 2005 Express databases were placed on C. Is there a way
to
| > > move
| > > them to my F drive were my Blackberry databse is stored.
| >
| >
| >
|
|||Dear George,
We wanted to see if the information provided was helpful. Please keep us
posted on your progress and let us know if you have any additional
questions or concerns.
We are looking forward to your response.
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| X-Tomcat-ID: 39541155
| References: <A002691D-AE4C-44C6-A0E8-EB5D0EC0E8DE@.microsoft.com>
<e99T0C1QIHA.4880@.TK2MSFTNGP03.phx.gbl>
<880D702B-D832-4405-9545-783FD1A79D87@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu@.online.microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Fri, 21 Dec 2007 04:20:19 GMT
| Subject: Re: Moving SQL 2005 Express Databases
| X-Tomcat-NG: microsoft.public.sqlserver.msde
| Message-ID: <cts5Oj4QIHA.1584@.TK2MSFTNGHUB02.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.msde
| Lines: 80
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.msde:842
| NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182
|
| Dear George,
|
| Thank you for posting here.
|
| The link (http://technet.microsoft.com/en-us/library/ms189133.aspx)
shared
| by RLF is valid. So, would you please test the again. In addition, I also
| would like to share with you the following KB article which also
describes
| the detail information on how to change the location of the data files
and
| of the log files for any Microsoft SQL Server 2005, SQL Server 2000, or
SQL
| Server 7.0 database.
|
| How to move SQL Server databases to a new location by using Detach and
| Attach functions in SQL Server
| http://support.microsoft.com/kb/224071
|
| Hope above information is helpful.
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu
| MCSE, MCDBA, MCTS
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| ================================================== ===
| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
| ================================================== ===
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
|
|
|
| --
| | Thread-Topic: Moving SQL 2005 Express Databases
| | thread-index: AchDaVKMcP7akeYMS+G8kuyf2UPqAQ==
| | X-WBNR-Posting-Host: 207.46.192.207
| | From: =?Utf-8?B?R2VvcmdlIFNjaG5laWRlcg==?=
| <georgedschneider@.noemail.noemail>
| | References: <A002691D-AE4C-44C6-A0E8-EB5D0EC0E8DE@.microsoft.com>
| <e99T0C1QIHA.4880@.TK2MSFTNGP03.phx.gbl>
| | Subject: Re: Moving SQL 2005 Express Databases
| | Date: Thu, 20 Dec 2007 16:35:01 -0800
| | Lines: 26
| | Message-ID: <880D702B-D832-4405-9545-783FD1A79D87@.microsoft.com>
| | MIME-Version: 1.0
| | Content-Type: text/plain;
| | charset="Utf-8"
| | Content-Transfer-Encoding: 7bit
| | X-Newsreader: Microsoft CDO for Windows 2000
| | Content-Class: urn:content-classes:message
| | Importance: normal
| | Priority: normal
| | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992
| | Newsgroups: microsoft.public.sqlserver.msde
| | Path: TK2MSFTNGHUB02.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.msde:841
| | NNTP-Posting-Host: tk2msftibfm01.phx.gbl 10.40.244.149
| | X-Tomcat-NG: microsoft.public.sqlserver.msde
| |
| | I get a page could not be found or has been moved page.
| |
| | "Russell Fields" wrote:
| |
| | > George,
| | >
| | > http://technet.microsoft.com/en-us/library/ms189133.aspx This page
is
| a
| | > link to two pages, one for user databases and one for system
databases.
| | > That should give you a cookbook to follow.
| | >
| | > RLF
| | >
| | >
| | > "George Schneider" <georgedschneider@.noemail.noemail> wrote in
message
| | > news:A002691D-AE4C-44C6-A0E8-EB5D0EC0E8DE@.microsoft.com...
| | > > As part of the installtion for my Blackberry Professional Software
| SQL
| | > > 2005
| | > > Express was installed. Unfortuantly during the install I was only
| able to
| | > > specify where the databases for the blackberry server were placed.
| The
| | > > rest
| | > > of the SQL 2005 Express databases were placed on C. Is there a
way
| to
| | > > move
| | > > them to my F drive were my Blackberry databse is stored.
| | >
| | >
| | >
| |
|
|

Moving production server to new box

I'm moving my prod server to a new box. Is the plan below
workable ?
I install the new server at the same SP level as the old
server.
I copy the mdf and ldf files to the new location.
I over write the mdf and ldf files for master with the old
servers copy.
I restart the server.
Since the directory structure is different, I assume that
master will come up but other db's will be suspect.
I update sysdatbases to point to the correct path for the
user databases.
I restart the server.
Is this too simplistic 'Please read this article, and do not move or overwrite MDF/LDF files with
the server shut down!:
http://support.microsoft.com/?kbid=224071
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message
news:1411901c41370$84d51b00$a301280a@.phx
.gbl...
> I'm moving my prod server to a new box. Is the plan below
> workable ?
> I install the new server at the same SP level as the old
> server.
> I copy the mdf and ldf files to the new location.
> I over write the mdf and ldf files for master with the old
> servers copy.
> I restart the server.
> Since the directory structure is different, I assume that
> master will come up but other db's will be suspect.
> I update sysdatbases to point to the correct path for the
> user databases.
> I restart the server.
> Is this too simplistic '
>|||A silly question but why not just use the Copy Database Wizard ?
http://msdn.microsoft.com/library/d...>
wiz_0z50.asp
J
-- Jack A wrote: --
I'm moving my prod server to a new box. Is the plan below
workable ?
I install the new server at the same SP level as the old
server.
I copy the mdf and ldf files to the new location.
I over write the mdf and ldf files for master with the old
servers copy.
I restart the server.
Since the directory structure is different, I assume that
master will come up but other db's will be suspect.
I update sysdatbases to point to the correct path for the
user databases.
I restart the server.
Is this too simplistic '|||Can i use this to move from a Sql 7 to Sql 2000. How do I
start the wizard. Cant find it anywhere in the interface.
>--Original Message--
>A silly question but why not just use the Copy Database
Wizard ?
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_onmigwiz_0z50.asp
>J
> -- Jack A wrote: --
> I'm moving my prod server to a new box. Is the plan
below
> workable ?
> I install the new server at the same SP level as the
old
> server.
> I copy the mdf and ldf files to the new location.
> I over write the mdf and ldf files for master with
the old
> servers copy.
> I restart the server.
> Since the directory structure is different, I assume
that
> master will come up but other db's will be suspect.
> I update sysdatbases to point to the correct path
for the
> user databases.
> I restart the server.
> Is this too simplistic '
>
>.
>|||The problem is if you have different path for the system databases. Move mas
ter and when you then start SQL
Server, it will look for model and tempdb in the *old* path, which might not
exists and SQL Server will not
start if it can't find these databases...
Moving SQL Server Databases
http://www.support.microsoft.com/?id=224071
Moving Databases between Servers
http://www.support.microsoft.com/?id=314546
Using WITH MOVE in a Restore to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=246133
Mapping Logins & SIDs after a Restore
http://www.support.microsoft.com/?id=298897
Utility to map users to the correct login
http://www.dbmaint.com/SyncSqlLogins.asp
How to Resolve Permission Issues When a Database Is Moved Between SQL Server
s
http://www.support.microsoft.com/?id=240872
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=168001
Disaster Recovery Articles for SQL Server
http://www.support.microsoft.com/?id=307775
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Jack A" <anonymous@.discussions.microsoft.com> wrote in message
news:1411901c41370$84d51b00$a301280a@.phx
.gbl...
> I'm moving my prod server to a new box. Is the plan below
> workable ?
> I install the new server at the same SP level as the old
> server.
> I copy the mdf and ldf files to the new location.
> I over write the mdf and ldf files for master with the old
> servers copy.
> I restart the server.
> Since the directory structure is different, I assume that
> master will come up but other db's will be suspect.
> I update sysdatbases to point to the correct path for the
> user databases.
> I restart the server.
> Is this too simplistic '
>|||HI
SQL 2000 Enterprise Manager: click 'Run a Wizard' button (or tools menu - Wi
zards...). Expand 'Management' and select 'Copy Database Wizard'.
Select a Source Server: Your old SQL 7.0 server. ...
-- Jack A wrote: --
Can i use this to move from a Sql 7 to Sql 2000. How do I
start the wizard. Cant find it anywhere in the interface.
>--Original Message--
>A silly question but why not just use the Copy Database
Wizard ?
url=/library/en-us/adminsql/ad_onmigwiz_0z50.asp
below
> workable ?
old
> server.
> I over write the mdf and ldf files for master with
the old
> servers copy.
> I restart the server.
> Since the directory structure is different, I assume
that
> master will come up but other db's will be suspect.
> I update sysdatbases to point to the correct path
for the
> user databases.
> I restart the server.
>