Discussion:
Moving SQL 2005 Express Databases
(too old to reply)
George Schneider
2007-12-20 20:19:01 UTC
Permalink
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.
Russell Fields
2007-12-20 21:38:45 UTC
Permalink
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
Post by George Schneider
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 Schneider
2007-12-21 00:35:01 UTC
Permalink
I get a page could not be found or has been moved page.
Post by Russell Fields
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
Post by George Schneider
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.
Adams Qu [MSFT]
2007-12-21 04:20:19 UTC
Permalink
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==?=
<***@noemail.noemail>
| References: <A002691D-AE4C-44C6-A0E8-***@microsoft.com>
<***@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-***@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" <***@noemail.noemail> wrote in message
| > news:A002691D-AE4C-44C6-A0E8-***@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.
| >
| >
| >
|
Adams Qu [MSFT]
2007-12-26 01:57:32 UTC
Permalink
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-***@microsoft.com>
<***@TK2MSFTNGP03.phx.gbl>
<880D702B-D832-4405-9545-***@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-***@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: <***@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==?=
| <***@noemail.noemail>
| | References: <A002691D-AE4C-44C6-A0E8-***@microsoft.com>
| <***@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-***@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" <***@noemail.noemail> wrote in
message
| | > news:A002691D-AE4C-44C6-A0E8-***@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.
| | >
| | >
| | >
| |
|
|

Loading...