from sql 2005 to sqlexpress 2005

Is there any way to export/import/copy a database from sql 2005 to sql
express2005?
Thanks.Detach/attach and backup/restore are two options.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Alex D." <alexware69@.hotmail.com> wrote in message news:emHL1HrbGHA.1960@.TK2MSFTNGP05.phx.gbl...
> Is there any way to export/import/copy a database from sql 2005 to sql
> express2005?
> Thanks.
>|||thanks I'll try dettach/attach cause restore is not working
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23SYgFvrbGHA.4716@.TK2MSFTNGP03.phx.gbl...
> Detach/attach and backup/restore are two options.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Alex D." <alexware69@.hotmail.com> wrote in message
> news:emHL1HrbGHA.1960@.TK2MSFTNGP05.phx.gbl...
>> Is there any way to export/import/copy a database from sql 2005 to sql
>> express2005?
>> Thanks.|||"Is not working" isn't a very good problem description. Restore should work, and if you show us some
details (the RESTORE command, error message etc), we can probably help you out with that. But attach
is a good option as well. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Alex D." <alexware69@.hotmail.com> wrote in message news:uouca9rbGHA.3352@.TK2MSFTNGP03.phx.gbl...
> thanks I'll try dettach/attach cause restore is not working
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:%23SYgFvrbGHA.4716@.TK2MSFTNGP03.phx.gbl...
>> Detach/attach and backup/restore are two options.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Alex D." <alexware69@.hotmail.com> wrote in message news:emHL1HrbGHA.1960@.TK2MSFTNGP05.phx.gbl...
>> Is there any way to export/import/copy a database from sql 2005 to sql express2005?
>> Thanks.
>|||The most likely cause of a failure here would be that the database is over
4GB so it can't run in Express. If that's the case, attach won't work
either.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ewa1khsbGHA.3504@.TK2MSFTNGP04.phx.gbl...
> "Is not working" isn't a very good problem description. Restore should
> work, and if you show us some details (the RESTORE command, error message
> etc), we can probably help you out with that. But attach is a good option
> as well. :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Alex D." <alexware69@.hotmail.com> wrote in message
> news:uouca9rbGHA.3352@.TK2MSFTNGP03.phx.gbl...
>> thanks I'll try dettach/attach cause restore is not working
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:%23SYgFvrbGHA.4716@.TK2MSFTNGP03.phx.gbl...
>> Detach/attach and backup/restore are two options.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Alex D." <alexware69@.hotmail.com> wrote in message
>> news:emHL1HrbGHA.1960@.TK2MSFTNGP05.phx.gbl...
>> Is there any way to export/import/copy a database from sql 2005 to sql
>> express2005?
>> Thanks.
>>
>|||Good catch, Roger. Didn't think about that... :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:uvu%23qvsbGHA.1320@.TK2MSFTNGP04.phx.gbl...
> The most likely cause of a failure here would be that the database is over 4GB so it can't run in
> Express. If that's the case, attach won't work either.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
>|||database is not over 4gb. the error message I am getting when trying to
restore is a permissions message. It seems that my new database dont have
permissions to restore the backup. I am using sql authentication and the sa
in both databases have the same password.
"Roger Wolter[MSFT]" <rwolter@.online.microsoft.com> wrote in message
news:uvu%23qvsbGHA.1320@.TK2MSFTNGP04.phx.gbl...
> The most likely cause of a failure here would be that the database is over
> 4GB so it can't run in Express. If that's the case, attach won't work
> either.
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
> in message news:ewa1khsbGHA.3504@.TK2MSFTNGP04.phx.gbl...
>> "Is not working" isn't a very good problem description. Restore should
>> work, and if you show us some details (the RESTORE command, error message
>> etc), we can probably help you out with that. But attach is a good option
>> as well. :-)
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Alex D." <alexware69@.hotmail.com> wrote in message
>> news:uouca9rbGHA.3352@.TK2MSFTNGP03.phx.gbl...
>> thanks I'll try dettach/attach cause restore is not working
>> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
>> in message news:%23SYgFvrbGHA.4716@.TK2MSFTNGP03.phx.gbl...
>> Detach/attach and backup/restore are two options.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Alex D." <alexware69@.hotmail.com> wrote in message
>> news:emHL1HrbGHA.1960@.TK2MSFTNGP05.phx.gbl...
>> Is there any way to export/import/copy a database from sql 2005 to sql
>> express2005?
>> Thanks.
>>
>