MOVing To SQL 2005 on Crystaltech.com

I have spent the last 2 months or so designing and modeling my new application backend in SQL Server 2005 Express edition.

I am ready to move it to a production copy of SQL Server 2005.

How do I go about this?

What kind of words can I put into google to bring some sort of results.

I have been looking in many places but no luck on how to take all the tables I have made (some with data, some not) and copy them to a live SQL 2005 Server.

Thanks in Advance for any help.

When I right-click on the Database in the Manager, I choose Tasks..

But Import / Export options are NOT THERE.

What do I do?

Why is this option not in my instance of SQL Express.

Thank you.

|||Depending on how you want the database hosted you could use detach/attach, backup/restore or scripting of schema and data.|||

How can I produce a schema? I'm assuming that is what I need to do. I am moving the database from my local machine (SQL Server Express) to a hosted SQL Server 2005 machine.

Thank you for your help,

Jon

|||You would need to write a few lines of code that call SMO.|||Jon,
I am in the same boat with my Express db. I have signed up with CrystalTech for hosting. Did you find a good solution to your problem?

Greg Lamb

Moving the database in SQL Server 2005 Express

Can someone tell me how to move the database from one drive to another? We
are running out of room on our drive.
Thanks!
Saucer Man wrote:
> Can someone tell me how to move the database from one drive to another? We
> are running out of room on our drive.
>
detach db, move files, attach db
you can find detach by right click on the database
you can find attach by right click on databases
|||Hi
ALTER DATABASE dbname SET OFFLINE
AER DATABASE dbname MODIFY FILE(NAME= dbname _dataFILENAME ='o:\Microsoft
SQL Server\MSSQL.1\MSSQL\Data\b.mdf')
ALTER DATABASE dbname MODIFY FILE(NAME= dbname_log,FILENAME ='d:\Microsoft
SQL Server\MSSQL.1\MSSQL\Data\bbbb.ldf')
ALTER DATABASE dbname SET ONLINE
"Saucer Man" <saucerman@.nospam.com> wrote in message
news:480497fc$0$19829$cc2e38e6@.news.uslec.net...
> Can someone tell me how to move the database from one drive to another?
> We are running out of room on our drive.
> --
> Thanks!
>
|||"Zarko Jovanovic" <mind_lessIsHsAsTsEsSsPsAsMs@.inet.hr> wrote in message
news:fu261j$erk$1@.sunce.iskon.hr...
> Saucer Man wrote:
> detach db, move files, attach db
> you can find detach by right click on the database
> you can find attach by right click on databases
>
Where do I right click the database? In Windows Explorer?
|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OwrQAw5nIHA.4292@.TK2MSFTNGP04.phx.gbl...
> Hi
> ALTER DATABASE dbname SET OFFLINE
> AER DATABASE dbname MODIFY FILE(NAME= dbname _dataFILENAME ='o:\Microsoft
> SQL Server\MSSQL.1\MSSQL\Data\b.mdf')
> ALTER DATABASE dbname MODIFY FILE(NAME= dbname_log,FILENAME ='d:\Microsoft
> SQL Server\MSSQL.1\MSSQL\Data\bbbb.ldf')
> ALTER DATABASE dbname SET ONLINE
>
I don't understand this. In this example, are you chaning a .mdf file on
one drive to a .ldf file on another drive?
|||Yes
I prefer to separate log amd data files.
"Saucer Man" <saucerman@.nospam.com> wrote in message
news:4805ecaf$0$19811$cc2e38e6@.news.uslec.net...
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OwrQAw5nIHA.4292@.TK2MSFTNGP04.phx.gbl...
> I don't understand this. In this example, are you chaning a .mdf file on
> one drive to a .ldf file on another drive?
>
|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ulaXx67nIHA.5096@.TK2MSFTNGP02.phx.gbl...
> Yes
> I prefer to separate log amd data files.
>
Actually I think to be perfectly clear, between the first ALTER DATABASE and
the AER (sic) DATABASE the step Uri assumed and didn't type out is:
xcopy b.mdf "o:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf"
xcopy bbbb.ldf "d:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf"
at the CMD prompt.
Then do the following 3 ALTER statements.

> "Saucer Man" <saucerman@.nospam.com> wrote in message
> news:4805ecaf$0$19811$cc2e38e6@.news.uslec.net...
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
|||Thanks Greg
I should have said that the OP at this moment has to copy files to the new
path.
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:uWdULg8nIHA.548@.TK2MSFTNGP06.phx.gbl...
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ulaXx67nIHA.5096@.TK2MSFTNGP02.phx.gbl...
> Actually I think to be perfectly clear, between the first ALTER DATABASE
> and the AER (sic) DATABASE the step Uri assumed and didn't type out is:
> xcopy b.mdf "o:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf"
> xcopy bbbb.ldf "d:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf"
> at the CMD prompt.
> Then do the following 3 ALTER statements.
>
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>
|||I thought AER was a typo and was supposed to ALTER. What does AER mean?
Once this is done, do the programs that use the database have to be adjusted
or will they automatically connect to the database in its new location?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23a14Rm8nIHA.548@.TK2MSFTNGP06.phx.gbl...
> Thanks Greg
> I should have said that the OP at this moment has to copy files to the new
> path.
>
>
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
> message news:uWdULg8nIHA.548@.TK2MSFTNGP06.phx.gbl...
>
|||Also, where do I enter these commands in 2005 Express?
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:uWdULg8nIHA.548@.TK2MSFTNGP06.phx.gbl...
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ulaXx67nIHA.5096@.TK2MSFTNGP02.phx.gbl...
> Actually I think to be perfectly clear, between the first ALTER DATABASE
> and the AER (sic) DATABASE the step Uri assumed and didn't type out is:
> xcopy b.mdf "o:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf"
> xcopy bbbb.ldf "d:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf"
> at the CMD prompt.
> Then do the following 3 ALTER statements.
>
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>
>
sql

Moving the database in SQL Server 2005 Express

Can someone tell me how to move the database from one drive to another? We
are running out of room on our drive.
--
Thanks!Saucer Man wrote:
> Can someone tell me how to move the database from one drive to another? We
> are running out of room on our drive.
>
detach db, move files, attach db
you can find detach by right click on the database
you can find attach by right click on databases|||Hi
ALTER DATABASE dbname SET OFFLINE
AER DATABASE dbname MODIFY FILE(NAME= dbname _dataFILENAME ='o:\Microsoft
SQL Server\MSSQL.1\MSSQL\Data\b.mdf')
ALTER DATABASE dbname MODIFY FILE(NAME= dbname_log,FILENAME ='d:\Microsoft
SQL Server\MSSQL.1\MSSQL\Data\bbbb.ldf')
ALTER DATABASE dbname SET ONLINE
"Saucer Man" <saucerman@.nospam.com> wrote in message
news:480497fc$0$19829$cc2e38e6@.news.uslec.net...
> Can someone tell me how to move the database from one drive to another?
> We are running out of room on our drive.
> --
> Thanks!
>|||"Zarko Jovanovic" <mind_lessIsHsAsTsEsSsPsAsMs@.inet.hr> wrote in message
news:fu261j$erk$1@.sunce.iskon.hr...
> Saucer Man wrote:
>> Can someone tell me how to move the database from one drive to another?
>> We are running out of room on our drive.
> detach db, move files, attach db
> you can find detach by right click on the database
> you can find attach by right click on databases
>
Where do I right click the database? In Windows Explorer?|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OwrQAw5nIHA.4292@.TK2MSFTNGP04.phx.gbl...
> Hi
> ALTER DATABASE dbname SET OFFLINE
> AER DATABASE dbname MODIFY FILE(NAME= dbname _dataFILENAME ='o:\Microsoft
> SQL Server\MSSQL.1\MSSQL\Data\b.mdf')
> ALTER DATABASE dbname MODIFY FILE(NAME= dbname_log,FILENAME ='d:\Microsoft
> SQL Server\MSSQL.1\MSSQL\Data\bbbb.ldf')
> ALTER DATABASE dbname SET ONLINE
>
I don't understand this. In this example, are you chaning a .mdf file on
one drive to a .ldf file on another drive?|||Yes
I prefer to separate log amd data files.
"Saucer Man" <saucerman@.nospam.com> wrote in message
news:4805ecaf$0$19811$cc2e38e6@.news.uslec.net...
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:OwrQAw5nIHA.4292@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> ALTER DATABASE dbname SET OFFLINE
>> AER DATABASE dbname MODIFY FILE(NAME= dbname _dataFILENAME ='o:\Microsoft
>> SQL Server\MSSQL.1\MSSQL\Data\b.mdf')
>> ALTER DATABASE dbname MODIFY FILE(NAME= dbname_log,FILENAME
>> ='d:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\bbbb.ldf')
>> ALTER DATABASE dbname SET ONLINE
>>
> I don't understand this. In this example, are you chaning a .mdf file on
> one drive to a .ldf file on another drive?
>|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ulaXx67nIHA.5096@.TK2MSFTNGP02.phx.gbl...
> Yes
> I prefer to separate log amd data files.
>
Actually I think to be perfectly clear, between the first ALTER DATABASE and
the AER (sic) DATABASE the step Uri assumed and didn't type out is:
xcopy b.mdf "o:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf"
xcopy bbbb.ldf "d:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf"
at the CMD prompt.
Then do the following 3 ALTER statements.
> "Saucer Man" <saucerman@.nospam.com> wrote in message
> news:4805ecaf$0$19811$cc2e38e6@.news.uslec.net...
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:OwrQAw5nIHA.4292@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> ALTER DATABASE dbname SET OFFLINE
>> AER DATABASE dbname MODIFY FILE(NAME= dbname _dataFILENAME
>> ='o:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf')
>> ALTER DATABASE dbname MODIFY FILE(NAME= dbname_log,FILENAME
>> ='d:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\bbbb.ldf')
>> ALTER DATABASE dbname SET ONLINE
>>
>> I don't understand this. In this example, are you chaning a .mdf file on
>> one drive to a .ldf file on another drive?
>
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Thanks Greg
I should have said that the OP at this moment has to copy files to the new
path.
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:uWdULg8nIHA.548@.TK2MSFTNGP06.phx.gbl...
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ulaXx67nIHA.5096@.TK2MSFTNGP02.phx.gbl...
>> Yes
>> I prefer to separate log amd data files.
> Actually I think to be perfectly clear, between the first ALTER DATABASE
> and the AER (sic) DATABASE the step Uri assumed and didn't type out is:
> xcopy b.mdf "o:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf"
> xcopy bbbb.ldf "d:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf"
> at the CMD prompt.
> Then do the following 3 ALTER statements.
>> "Saucer Man" <saucerman@.nospam.com> wrote in message
>> news:4805ecaf$0$19811$cc2e38e6@.news.uslec.net...
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:OwrQAw5nIHA.4292@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> ALTER DATABASE dbname SET OFFLINE
>> AER DATABASE dbname MODIFY FILE(NAME= dbname _dataFILENAME
>> ='o:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf')
>> ALTER DATABASE dbname MODIFY FILE(NAME= dbname_log,FILENAME
>> ='d:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\bbbb.ldf')
>> ALTER DATABASE dbname SET ONLINE
>>
>> I don't understand this. In this example, are you chaning a .mdf file
>> on one drive to a .ldf file on another drive?
>>
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>|||I thought AER was a typo and was supposed to ALTER. What does AER mean?
Once this is done, do the programs that use the database have to be adjusted
or will they automatically connect to the database in its new location?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23a14Rm8nIHA.548@.TK2MSFTNGP06.phx.gbl...
> Thanks Greg
> I should have said that the OP at this moment has to copy files to the new
> path.
>
>
> "Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in
> message news:uWdULg8nIHA.548@.TK2MSFTNGP06.phx.gbl...
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:ulaXx67nIHA.5096@.TK2MSFTNGP02.phx.gbl...
>> Yes
>> I prefer to separate log amd data files.
>>
>> Actually I think to be perfectly clear, between the first ALTER DATABASE
>> and the AER (sic) DATABASE the step Uri assumed and didn't type out is:
>> xcopy b.mdf "o:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf"
>> xcopy bbbb.ldf "d:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf"
>> at the CMD prompt.
>> Then do the following 3 ALTER statements.
>> "Saucer Man" <saucerman@.nospam.com> wrote in message
>> news:4805ecaf$0$19811$cc2e38e6@.news.uslec.net...
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:OwrQAw5nIHA.4292@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> ALTER DATABASE dbname SET OFFLINE
>> AER DATABASE dbname MODIFY FILE(NAME= dbname _dataFILENAME
>> ='o:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf')
>> ALTER DATABASE dbname MODIFY FILE(NAME= dbname_log,FILENAME
>> ='d:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\bbbb.ldf')
>> ALTER DATABASE dbname SET ONLINE
>>
>> I don't understand this. In this example, are you chaning a .mdf file
>> on one drive to a .ldf file on another drive?
>>
>>
>>
>> --
>> Greg Moore
>> SQL Server DBA Consulting Remote and Onsite available!
>> Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
>>
>|||Also, where do I enter these commands in 2005 Express?
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:uWdULg8nIHA.548@.TK2MSFTNGP06.phx.gbl...
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ulaXx67nIHA.5096@.TK2MSFTNGP02.phx.gbl...
>> Yes
>> I prefer to separate log amd data files.
> Actually I think to be perfectly clear, between the first ALTER DATABASE
> and the AER (sic) DATABASE the step Uri assumed and didn't type out is:
> xcopy b.mdf "o:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf"
> xcopy bbbb.ldf "d:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf"
> at the CMD prompt.
> Then do the following 3 ALTER statements.
>> "Saucer Man" <saucerman@.nospam.com> wrote in message
>> news:4805ecaf$0$19811$cc2e38e6@.news.uslec.net...
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:OwrQAw5nIHA.4292@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> ALTER DATABASE dbname SET OFFLINE
>> AER DATABASE dbname MODIFY FILE(NAME= dbname _dataFILENAME
>> ='o:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\b.mdf')
>> ALTER DATABASE dbname MODIFY FILE(NAME= dbname_log,FILENAME
>> ='d:\Microsoft SQL Server\MSSQL.1\MSSQL\Data\bbbb.ldf')
>> ALTER DATABASE dbname SET ONLINE
>>
>> I don't understand this. In this example, are you chaning a .mdf file
>> on one drive to a .ldf file on another drive?
>>
>
> --
> Greg Moore
> SQL Server DBA Consulting Remote and Onsite available!
> Email: sql (at) greenms.com
> http://www.greenms.com/sqlserver.html
>
>|||"Saucer Man" <saucerman@.nospam.com> wrote in message
news:48061cde$0$19820$cc2e38e6@.news.uslec.net...
> Also, where do I enter these commands in 2005 Express?
>
Anyone?|||Either use the SQLCMD tool (comes with Express) or download the "SQL Server Management Studio
Express" tool from MS.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Saucer Man" <saucerman@.nospam.com> wrote in message
news:48074bf8$0$19860$cc2e38e6@.news.uslec.net...
> "Saucer Man" <saucerman@.nospam.com> wrote in message
> news:48061cde$0$19820$cc2e38e6@.news.uslec.net...
>> Also, where do I enter these commands in 2005 Express?
>
> Anyone?
>|||"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23j2$wgJoIHA.5016@.TK2MSFTNGP02.phx.gbl...
> Either use the SQLCMD tool (comes with Express) or download the "SQL
> Server Management Studio Express" tool from MS.
>
Thanks!

Moving SQL Express data to SQL Server 2005 Dev?

Hi gang,
Sorry for the bloody obviousness of this quetion, but I'm a unix/mysql
guy who's been tasked with moving an web app developed with SQL
Express (specifically RedDot CMS) to SQL Server 2005 Developer, and,
having literally NO working experience with the Microsoft products, am
wondering how one would migrate data from SQL Express to SQL Server
proper...
Any help or advice in this matter is most appreciated, I've trolled
this group but found no concrete info. Reading the documentation is
says it can be done at time of install, but, given my apprehension of
MS products reliability, is this a safe way to move a mission critical
DB?
Thanks a million,
Cheers
- Randall"MSSQL-n00b" <spliffhuxtable@.gmail.com> wrote in message
news:1174576289.977944.137500@.b75g2000hsg.googlegroups.com...
> Hi gang,
> Sorry for the bloody obviousness of this quetion, but I'm a unix/mysql
> guy who's been tasked with moving an web app developed with SQL
> Express (specifically RedDot CMS) to SQL Server 2005 Developer, and,
> having literally NO working experience with the Microsoft products, am
> wondering how one would migrate data from SQL Express to SQL Server
> proper...
> Any help or advice in this matter is most appreciated, I've trolled
> this group but found no concrete info. Reading the documentation is
> says it can be done at time of install, but, given my apprehension of
> MS products reliability, is this a safe way to move a mission critical
> DB?
> Thanks a million,
>
SQL Server Express uses the same engine and has the same file format as the
other editions of SQL Server. So you can take a backup of the database from
Express and restore it on another edition, you can detach the database and
attach it on another edition, or you can upgrade the Express edition to a
higher edition.
David

Moving SQL Express data to SQL Server 2005 Dev?

Hi gang,
Sorry for the bloody obviousness of this quetion, but I'm a unix/mysql
guy who's been tasked with moving an web app developed with SQL
Express (specifically RedDot CMS) to SQL Server 2005 Developer, and,
having literally NO working experience with the Microsoft products, am
wondering how one would migrate data from SQL Express to SQL Server
proper...
Any help or advice in this matter is most appreciated, I've trolled
this group but found no concrete info. Reading the documentation is
says it can be done at time of install, but, given my apprehension of
MS products reliability, is this a safe way to move a mission critical
DB?
Thanks a million,
Cheers
- Randall
"MSSQL-n00b" <spliffhuxtable@.gmail.com> wrote in message
news:1174576289.977944.137500@.b75g2000hsg.googlegr oups.com...
> Hi gang,
> Sorry for the bloody obviousness of this quetion, but I'm a unix/mysql
> guy who's been tasked with moving an web app developed with SQL
> Express (specifically RedDot CMS) to SQL Server 2005 Developer, and,
> having literally NO working experience with the Microsoft products, am
> wondering how one would migrate data from SQL Express to SQL Server
> proper...
> Any help or advice in this matter is most appreciated, I've trolled
> this group but found no concrete info. Reading the documentation is
> says it can be done at time of install, but, given my apprehension of
> MS products reliability, is this a safe way to move a mission critical
> DB?
> Thanks a million,
>
SQL Server Express uses the same engine and has the same file format as the
other editions of SQL Server. So you can take a backup of the database from
Express and restore it on another edition, you can detach the database and
attach it on another edition, or you can upgrade the Express edition to a
higher edition.
David

Moving SQL Express data to SQL Server 2005 Dev?

Hi gang,
Sorry for the bloody obviousness of this quetion, but I'm a unix/mysql
guy who's been tasked with moving an web app developed with SQL
Express (specifically RedDot CMS) to SQL Server 2005 Developer, and,
having literally NO working experience with the Microsoft products, am
wondering how one would migrate data from SQL Express to SQL Server
proper...
Any help or advice in this matter is most appreciated, I've trolled
this group but found no concrete info. Reading the documentation is
says it can be done at time of install, but, given my apprehension of
MS products reliability, is this a safe way to move a mission critical
DB?
Thanks a million,
Cheers
- Randall"MSSQL-n00b" <spliffhuxtable@.gmail.com> wrote in message
news:1174576289.977944.137500@.b75g2000hsg.googlegroups.com...
> Hi gang,
> Sorry for the bloody obviousness of this quetion, but I'm a unix/mysql
> guy who's been tasked with moving an web app developed with SQL
> Express (specifically RedDot CMS) to SQL Server 2005 Developer, and,
> having literally NO working experience with the Microsoft products, am
> wondering how one would migrate data from SQL Express to SQL Server
> proper...
> Any help or advice in this matter is most appreciated, I've trolled
> this group but found no concrete info. Reading the documentation is
> says it can be done at time of install, but, given my apprehension of
> MS products reliability, is this a safe way to move a mission critical
> DB?
> Thanks a million,
>
SQL Server Express uses the same engine and has the same file format as the
other editions of SQL Server. So you can take a backup of the database from
Express and restore it on another edition, you can detach the database and
attach it on another edition, or you can upgrade the Express edition to a
higher edition.
David

Moving SQL 2005 Express dbs using SQL Server Management Express Studio?

Is it possible to move a SQL 2005 Express database using the SQL Server
Management Express 2005 Studio tools? I am trying to move the default
databases for Sharepoint MOSS 2007 from a C: partition to a D: partition,
and would like to know if I can do this with the SME 2005 tools, rather than
using the command line method in KB224071.
Also, is there a list of what the default databases are for MOSS 2007, so I
can make sure that I move all the databases?
Thanks,
Rob G.
Hi Robert
"Robert Gordon" wrote:

> Is it possible to move a SQL 2005 Express database using the SQL Server
> Management Express 2005 Studio tools? I am trying to move the default
> databases for Sharepoint MOSS 2007 from a C: partition to a D: partition,
> and would like to know if I can do this with the SME 2005 tools, rather than
> using the command line method in KB224071.
> Also, is there a list of what the default databases are for MOSS 2007, so I
> can make sure that I move all the databases?
> Thanks,
> Rob G.
>
I am not sure about SQL Express Manager, but you can always use sp_detach_db
and sp_attach_db from a command prompt and SQLCMD see
http://support.microsoft.com/kb/224071/
John

Moving SQL 2005 Express dbs using SQL Server Management Express Studio?

Is it possible to move a SQL 2005 Express database using the SQL Server
Management Express 2005 Studio tools? I am trying to move the default
databases for Sharepoint MOSS 2007 from a C: partition to a D: partition,
and would like to know if I can do this with the SME 2005 tools, rather than
using the command line method in KB224071.
Also, is there a list of what the default databases are for MOSS 2007, so I
can make sure that I move all the databases?
Thanks,
Rob G.Hi Robert
"Robert Gordon" wrote:
> Is it possible to move a SQL 2005 Express database using the SQL Server
> Management Express 2005 Studio tools? I am trying to move the default
> databases for Sharepoint MOSS 2007 from a C: partition to a D: partition,
> and would like to know if I can do this with the SME 2005 tools, rather than
> using the command line method in KB224071.
> Also, is there a list of what the default databases are for MOSS 2007, so I
> can make sure that I move all the databases?
> Thanks,
> Rob G.
>
I am not sure about SQL Express Manager, but you can always use sp_detach_db
and sp_attach_db from a command prompt and SQLCMD see
http://support.microsoft.com/kb/224071/
John

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.
| | >
| | >
| | >
| |
|
|