Moving Log Files: local

Showing posts with label local. Show all posts

Friday, March 30, 2012

moving...

Hi ,

We have a database around 5GB in size, located in remote location . i want to get that database into my local machine. We cannot take back up in tape or any other media from our remote location ,so we have to depend on FTP .

Is there any better solution other than FTP, or DTS import/Export , to transfer whole database to my local machine ?

Please give me some suggestions !

Thanks,

HadleyIts better to take file backup and use FTP to transfer the file. Before than make sure to run DBCC checks against the database to keep it clean.

Even you can use Generate SQL Scripts and run those scripts on the local machine, then use DTS to transfer the data.

HTH

Monday, March 19, 2012

Moving SQL Server application onto MSDE server

I'm pretty new to SQL Server so any help on this would be
appreciated.
I have SQL Server 2000 database on my local machine and
have developed a web application (ASP) which accesses this
database.
I now have a remote hosted server (Windows 2000) running
MSDE.
I've moved the ASP pages onto the remote server but how do
I move the MS SQL database to the server so it uses the
MSDE engine? Can I just copy the MDF and LDF files to the
data directory and is everything else the same or are
there other modifications I need to perform?
Thanks for your help?
ChoccyIt is relatively easy to move the database... One way is to use the copy
database wizard in SQL Enterprise Manager...
Make sure no one is using the source database.. Right click databases. ->
all tasks -> copy database wizard... The Login you are using must have write
access to the directories where you wish the new database to go... follow
the wizard and you are goo.
Doing the same thing manually involves using sp_detach_db, copy the mdf, and
ldf files to the new location... Then use sp_attach_db twice, First to
attach the database to the new server, then to attache the database back to
the original server.
Lastly you may use backup.restore to do the job..
The only thing which might be a problem is that the users in your database
map to SQL logins in master. The logins available in the new server may not
match the old server... Read about "Moving a database to a different
server" by searching on MSDN web site, or look for "Log Shipping" in books
on line... Both describe how to re-match users with logins. (It will not be
a huge problem, but one you should address.)
Good luck, and have great success!
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Choccy" <choccy@.chocolateteapot.com> wrote in message
news:4e5201c37c3b$941ae0d0$a601280a@.phx.gbl...
> I'm pretty new to SQL Server so any help on this would be
> appreciated.
> I have SQL Server 2000 database on my local machine and
> have developed a web application (ASP) which accesses this
> database.
> I now have a remote hosted server (Windows 2000) running
> MSDE.
> I've moved the ASP pages onto the remote server but how do
> I move the MS SQL database to the server so it uses the
> MSDE engine? Can I just copy the MDF and LDF files to the
> data directory and is everything else the same or are
> there other modifications I need to perform?
> Thanks for your help?
> Choccy|||If your SQL2k DB is < 2GB, sp_detachdb would work.
--
HTH
Ryan Waight, MCDBA, MCSE
"Choccy" <choccy@.chocolateteapot.com> wrote in message
news:4e5201c37c3b$941ae0d0$a601280a@.phx.gbl...
> I'm pretty new to SQL Server so any help on this would be
> appreciated.
> I have SQL Server 2000 database on my local machine and
> have developed a web application (ASP) which accesses this
> database.
> I now have a remote hosted server (Windows 2000) running
> MSDE.
> I've moved the ASP pages onto the remote server but how do
> I move the MS SQL database to the server so it uses the
> MSDE engine? Can I just copy the MDF and LDF files to the
> data directory and is everything else the same or are
> there other modifications I need to perform?
> Thanks for your help?
> Choccy|||Wayne,
thanks for the speedy reply.
I only have access to the remote server across the web, it
is not on a network of mine. I guess that rules out using
the Enterprise Manager?
Therefore I will try your other suggestions and hopefully
I will get it to work OK.
Cheers
Choccy
>--Original Message--
>It is relatively easy to move the database... One way is
to use the copy
>database wizard in SQL Enterprise Manager...
>Make sure no one is using the source database.. Right
click databases. ->
>all tasks -> copy database wizard... The Login you are
using must have write
>access to the directories where you wish the new database
to go... follow
>the wizard and you are goo.
>Doing the same thing manually involves using
sp_detach_db, copy the mdf, and
>ldf files to the new location... Then use sp_attach_db
twice, First to
>attach the database to the new server, then to attache
the database back to
>the original server.
>Lastly you may use backup.restore to do the job..
>The only thing which might be a problem is that the users
in your database
>map to SQL logins in master. The logins available in the
new server may not
>match the old server... Read about "Moving a database to
a different
>server" by searching on MSDN web site, or look for "Log
Shipping" in books
>on line... Both describe how to re-match users with
logins. (It will not be
>a huge problem, but one you should address.)
>Good luck, and have great success!
>--
>Wayne Snyder, MCDBA, SQL Server MVP
>Computer Education Services Corporation (CESC),
Charlotte, NC
>www.computeredservices.com
>(Please respond only to the newsgroups.)
>I support the Professional Association of SQL Server
(PASS) and it's
>community of SQL Server professionals.
>www.sqlpass.org
>
>"Choccy" <choccy@.chocolateteapot.com> wrote in message
>news:4e5201c37c3b$941ae0d0$a601280a@.phx.gbl...
>> I'm pretty new to SQL Server so any help on this would
be
>> appreciated.
>> I have SQL Server 2000 database on my local machine and
>> have developed a web application (ASP) which accesses
this
>> database.
>> I now have a remote hosted server (Windows 2000) running
>> MSDE.
>> I've moved the ASP pages onto the remote server but how
do
>> I move the MS SQL database to the server so it uses the
>> MSDE engine? Can I just copy the MDF and LDF files to
the
>> data directory and is everything else the same or are
>> there other modifications I need to perform?
>> Thanks for your help?
>> Choccy
>
>.
>|||This might be of interest as well:
http://www.support.microsoft.com/?id=314546 Moving DB's between Servers
http://www.support.microsoft.com/?id=224071 Moving SQL Server Databases
to a New Location with Detach/Attach
http://support.microsoft.com/?id=221465 Using WITH MOVE in a
Restore
http://www.support.microsoft.com/?id=246133 How To Transfer Logins and
Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
--
Andrew J. Kelly
SQL Server MVP
"Choccy" <choccy@.chocolateteapot.com> wrote in message
news:041701c37c3f$fd9a5640$a001280a@.phx.gbl...
> Wayne,
> thanks for the speedy reply.
> I only have access to the remote server across the web, it
> is not on a network of mine. I guess that rules out using
> the Enterprise Manager?
> Therefore I will try your other suggestions and hopefully
> I will get it to work OK.
> Cheers
> Choccy
>
> >--Original Message--
> >It is relatively easy to move the database... One way is
> to use the copy
> >database wizard in SQL Enterprise Manager...
> >Make sure no one is using the source database.. Right
> click databases. ->
> >all tasks -> copy database wizard... The Login you are
> using must have write
> >access to the directories where you wish the new database
> to go... follow
> >the wizard and you are goo.
> >Doing the same thing manually involves using
> sp_detach_db, copy the mdf, and
> >ldf files to the new location... Then use sp_attach_db
> twice, First to
> >attach the database to the new server, then to attache
> the database back to
> >the original server.
> >
> >Lastly you may use backup.restore to do the job..
> >
> >The only thing which might be a problem is that the users
> in your database
> >map to SQL logins in master. The logins available in the
> new server may not
> >match the old server... Read about "Moving a database to
> a different
> >server" by searching on MSDN web site, or look for "Log
> Shipping" in books
> >on line... Both describe how to re-match users with
> logins. (It will not be
> >a huge problem, but one you should address.)
> >
> >Good luck, and have great success!
> >
> >--
> >Wayne Snyder, MCDBA, SQL Server MVP
> >Computer Education Services Corporation (CESC),
> Charlotte, NC
> >www.computeredservices.com
> >(Please respond only to the newsgroups.)
> >
> >I support the Professional Association of SQL Server
> (PASS) and it's
> >community of SQL Server professionals.
> >www.sqlpass.org
> >
> >
> >"Choccy" <choccy@.chocolateteapot.com> wrote in message
> >news:4e5201c37c3b$941ae0d0$a601280a@.phx.gbl...
> >> I'm pretty new to SQL Server so any help on this would
> be
> >> appreciated.
> >>
> >> I have SQL Server 2000 database on my local machine and
> >> have developed a web application (ASP) which accesses
> this
> >> database.
> >> I now have a remote hosted server (Windows 2000) running
> >> MSDE.
> >> I've moved the ASP pages onto the remote server but how
> do
> >> I move the MS SQL database to the server so it uses the
> >> MSDE engine? Can I just copy the MDF and LDF files to
> the
> >> data directory and is everything else the same or are
> >> there other modifications I need to perform?
> >>
> >> Thanks for your help?
> >>
> >> Choccy
> >
> >
> >.
> >

Monday, March 12, 2012

Moving SQL data to another Local Disk

How simple is it to relocate the SQL data to another local disk on
the server. Our drive that we are currently using for SQL is getting
full and we are installing a RAID1 configuration to use specifically for
SQL, but I need to know the how difficult it will be to move it to
another location. If it is simple, what are the steps for this process? Thank
you in advance.Basically you are going to Detach the DB, move the .mdf data file and
reattach the database.
Here is great how to article from Microsoft.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_design_4wq1.asp
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Phil Buzzette" <PhilBuzzette@.discussions.microsoft.com> wrote in message
news:15583E07-D763-4CFE-85E5-F825AB906203@.microsoft.com...
> How simple is it to relocate the SQL data to another local disk on
> the server. Our drive that we are currently using for SQL is getting
> full and we are installing a RAID1 configuration to use specifically for
> SQL, but I need to know the how difficult it will be to move it to
> another location. If it is simple, what are the steps for this process?
> Thank
> you in advance.
>|||Thank you. This is exactly what I needed.
"Warren Brunk" wrote:
> Basically you are going to Detach the DB, move the .mdf data file and
> reattach the database.
> Here is great how to article from Microsoft.
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_design_4wq1.asp
>
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> */
>
> "Phil Buzzette" <PhilBuzzette@.discussions.microsoft.com> wrote in message
> news:15583E07-D763-4CFE-85E5-F825AB906203@.microsoft.com...
> > How simple is it to relocate the SQL data to another local disk on
> > the server. Our drive that we are currently using for SQL is getting
> > full and we are installing a RAID1 configuration to use specifically for
> > SQL, but I need to know the how difficult it will be to move it to
> > another location. If it is simple, what are the steps for this process?
> > Thank
> > you in advance.
> >
>
>|||before detaching the database , run checkpoint command.
Phil Buzzette wrote:
> Thank you. This is exactly what I needed.
> "Warren Brunk" wrote:
>> Basically you are going to Detach the DB, move the .mdf data file and
>> reattach the database.
>> Here is great how to article from Microsoft.
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_design_4wq1.asp
>>
>> --
>> /*
>> Warren Brunk - MCITP - SQL 2005, MCDBA
>> www.techintsolutions.com
>> */
>>
>> "Phil Buzzette" <PhilBuzzette@.discussions.microsoft.com> wrote in message
>> news:15583E07-D763-4CFE-85E5-F825AB906203@.microsoft.com...
>> How simple is it to relocate the SQL data to another local disk on
>> the server. Our drive that we are currently using for SQL is getting
>> full and we are installing a RAID1 configuration to use specifically for
>> SQL, but I need to know the how difficult it will be to move it to
>> another location. If it is simple, what are the steps for this process?
>> Thank
>> you in advance.
>>|||before detaching the database , run checkpoint command.
--krishna
Phil Buzzette wrote:
> Thank you. This is exactly what I needed.
> "Warren Brunk" wrote:
>> Basically you are going to Detach the DB, move the .mdf data file and
>> reattach the database.
>> Here is great how to article from Microsoft.
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_design_4wq1.asp
>>
>> --
>> /*
>> Warren Brunk - MCITP - SQL 2005, MCDBA
>> www.techintsolutions.com
>> */
>>
>> "Phil Buzzette" <PhilBuzzette@.discussions.microsoft.com> wrote in message
>> news:15583E07-D763-4CFE-85E5-F825AB906203@.microsoft.com...
>> How simple is it to relocate the SQL data to another local disk on
>> the server. Our drive that we are currently using for SQL is getting
>> full and we are installing a RAID1 configuration to use specifically for
>> SQL, but I need to know the how difficult it will be to move it to
>> another location. If it is simple, what are the steps for this process?
>> Thank
>> you in advance.
>>|||Not familiar with that. Could you please explain. I am somewhat new to SQL. I
just have to do this for a customer.
"krishna" wrote:
> before detaching the database , run checkpoint command.
> --krishna
> Phil Buzzette wrote:
> > Thank you. This is exactly what I needed.
> >
> > "Warren Brunk" wrote:
> >
> >> Basically you are going to Detach the DB, move the .mdf data file and
> >> reattach the database.
> >>
> >> Here is great how to article from Microsoft.
> >>
> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_design_4wq1.asp
> >>
> >>
> >>
> >> --
> >> /*
> >> Warren Brunk - MCITP - SQL 2005, MCDBA
> >> www.techintsolutions.com
> >> */
> >>
> >>
> >> "Phil Buzzette" <PhilBuzzette@.discussions.microsoft.com> wrote in message
> >> news:15583E07-D763-4CFE-85E5-F825AB906203@.microsoft.com...
> >> How simple is it to relocate the SQL data to another local disk on
> >> the server. Our drive that we are currently using for SQL is getting
> >> full and we are installing a RAID1 configuration to use specifically for
> >> SQL, but I need to know the how difficult it will be to move it to
> >> another location. If it is simple, what are the steps for this process?
> >> Thank
> >> you in advance.
> >>
> >>
> >>
>|||the checkpoint command writes all data stored in memory to disk to ensure
that all data is held in the .mdf database file.
it is a good practice when moving databases using the detach method.
There are alot of things that trigger a checkpoint such as a back up comman
with No_Log option and starting and stopping the SQL server or you can run
Checkpoint in your query analyzer.
thanks,
--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"Phil Buzzette" <PhilBuzzette@.discussions.microsoft.com> wrote in message
news:50341C73-9539-43A2-A539-AC30BE7F7F59@.microsoft.com...
> Not familiar with that. Could you please explain. I am somewhat new to
> SQL. I
> just have to do this for a customer.
> "krishna" wrote:
>> before detaching the database , run checkpoint command.
>> --krishna
>> Phil Buzzette wrote:
>> > Thank you. This is exactly what I needed.
>> >
>> > "Warren Brunk" wrote:
>> >
>> >> Basically you are going to Detach the DB, move the .mdf data file and
>> >> reattach the database.
>> >>
>> >> Here is great how to article from Microsoft.
>> >>
>> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_design_4wq1.asp
>> >>
>> >>
>> >>
>> >> --
>> >> /*
>> >> Warren Brunk - MCITP - SQL 2005, MCDBA
>> >> www.techintsolutions.com
>> >> */
>> >>
>> >>
>> >> "Phil Buzzette" <PhilBuzzette@.discussions.microsoft.com> wrote in
>> >> message
>> >> news:15583E07-D763-4CFE-85E5-F825AB906203@.microsoft.com...
>> >> How simple is it to relocate the SQL data to another local disk on
>> >> the server. Our drive that we are currently using for SQL is getting
>> >> full and we are installing a RAID1 configuration to use specifically
>> >> for
>> >> SQL, but I need to know the how difficult it will be to move it to
>> >> another location. If it is simple, what are the steps for this
>> >> process?
>> >> Thank
>> >> you in advance.
>> >>
>> >>
>> >>

Wednesday, March 7, 2012

moving primary log file

hi,
i'm running out of space on my local drive. the db that i am working on has
one log file. i'd like to move it to a network drive. is that allowed?
i've gotten an error message to the contrary when i tried this w/ a test db.
also, how do a i move a primary log file for a database?
thank you
matthew
I would try sp_detach_db/ sp_attach_db.
"matthew c. harad" <matthewcharad@.discussions.microsoft.com> wrote in
message news:3FD18944-59E5-48EE-A306-A35C93329FD9@.microsoft.com...
> hi,
> i'm running out of space on my local drive. the db that i am working on
has
> one log file. i'd like to move it to a network drive. is that allowed?
> i've gotten an error message to the contrary when i tried this w/ a test
db.
> also, how do a i move a primary log file for a database?
> thank you
> matthew
|||Hi
You can't put it onto a "normal" network drive, but if you have a SAN that
is ok. You may want to detach the database (sp_detach_db) and attach just the
data file to create a new (smaller) log file see sp_attach_single_file_db in
books online. To keep the existing one you can use sp_attach_db specifying
the new location of the log, or backup/restore the database using the MOVE
clause (or changing the location in the Advanced tab in EM).
John
"matthew c. harad" wrote:

> hi,
> i'm running out of space on my local drive. the db that i am working on has
> one log file. i'd like to move it to a network drive. is that allowed?
> i've gotten an error message to the contrary when i tried this w/ a test db.
> also, how do a i move a primary log file for a database?
> thank you
> matthew

moving primary log file

hi,
i'm running out of space on my local drive. the db that i am working on has
one log file. i'd like to move it to a network drive. is that allowed?
i've gotten an error message to the contrary when i tried this w/ a test db.
also, how do a i move a primary log file for a database?
thank you
matthewI would try sp_detach_db/ sp_attach_db.
"matthew c. harad" <matthewcharad@.discussions.microsoft.com> wrote in
message news:3FD18944-59E5-48EE-A306-A35C93329FD9@.microsoft.com...
> hi,
> i'm running out of space on my local drive. the db that i am working on
has
> one log file. i'd like to move it to a network drive. is that allowed?
> i've gotten an error message to the contrary when i tried this w/ a test
db.
> also, how do a i move a primary log file for a database?
> thank you
> matthew|||Hi
You can't put it onto a "normal" network drive, but if you have a SAN that
is ok. You may want to detach the database (sp_detach_db) and attach just th
e
data file to create a new (smaller) log file see sp_attach_single_file_db in
books online. To keep the existing one you can use sp_attach_db specifying
the new location of the log, or backup/restore the database using the MOVE
clause (or changing the location in the Advanced tab in EM).
John
"matthew c. harad" wrote:

> hi,
> i'm running out of space on my local drive. the db that i am working on h
as
> one log file. i'd like to move it to a network drive. is that allowed?
> i've gotten an error message to the contrary when i tried this w/ a test d
b.
> also, how do a i move a primary log file for a database?
> thank you
> matthew

moving primary log file

hi,
i'm running out of space on my local drive. the db that i am working on has
one log file. i'd like to move it to a network drive. is that allowed?
i've gotten an error message to the contrary when i tried this w/ a test db.
also, how do a i move a primary log file for a database?
thank you
matthewI would try sp_detach_db/ sp_attach_db.
"matthew c. harad" <matthewcharad@.discussions.microsoft.com> wrote in
message news:3FD18944-59E5-48EE-A306-A35C93329FD9@.microsoft.com...
> hi,
> i'm running out of space on my local drive. the db that i am working on
has
> one log file. i'd like to move it to a network drive. is that allowed?
> i've gotten an error message to the contrary when i tried this w/ a test
db.
> also, how do a i move a primary log file for a database?
> thank you
> matthew|||Hi
You can't put it onto a "normal" network drive, but if you have a SAN that
is ok. You may want to detach the database (sp_detach_db) and attach just the
data file to create a new (smaller) log file see sp_attach_single_file_db in
books online. To keep the existing one you can use sp_attach_db specifying
the new location of the log, or backup/restore the database using the MOVE
clause (or changing the location in the Advanced tab in EM).
John
"matthew c. harad" wrote:
> hi,
> i'm running out of space on my local drive. the db that i am working on has
> one log file. i'd like to move it to a network drive. is that allowed?
> i've gotten an error message to the contrary when i tried this w/ a test db.
> also, how do a i move a primary log file for a database?
> thank you
> matthew

Saturday, February 25, 2012

moving MSDE database to SQL...

rI have an end-use that created a database on MSDE and is housing it on
his local computer. We want to move/copy it to our SQL server so it
can be backed up etc. What are the appropriate steps in doing so?
Thanks in advance,
KenIf they have both the same (and probably latest) service packs, the
compatibility is 100% and you don't have to take any special step (excerpt
maybe for authentification and login information). So a Backup/Restore or a
Detach/Reattach operation will be the easiest way.
S. L.
"Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
news:1CE3E73D-87E1-4058-BDAC-5D2FDB3984FE@.microsoft.com...
> rI have an end-use that created a database on MSDE and is housing it on
> his local computer. We want to move/copy it to our SQL server so it
> can be backed up etc. What are the appropriate steps in doing so?
> Thanks in advance,
> Ken
>|||Thanks for the reply, but I have no idea what the command lines are for MSDE
in order to backup etc. Where would I find those that I need in order to
backup and then restore to the SQL server?
Thanks,
Ken
"Sylvain Lafontaine" wrote:
> If they have both the same (and probably latest) service packs, the
> compatibility is 100% and you don't have to take any special step (excerpt
> maybe for authentification and login information). So a Backup/Restore or a
> Detach/Reattach operation will be the easiest way.
> S. L.
> "Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
> news:1CE3E73D-87E1-4058-BDAC-5D2FDB3984FE@.microsoft.com...
> > rI have an end-use that created a database on MSDE and is housing it on
> > his local computer. We want to move/copy it to our SQL server so it
> > can be backed up etc. What are the appropriate steps in doing so?
> >
> > Thanks in advance,
> >
> > Ken
> >
>
>|||Well, look up BACKUP DATABASE in Books Online, and to execute it against
MSDE, you can use
osql -S(local)\instancename -E -Q"BACKUP DATABASE ..."
or
osql -S(local)\instancename -E -Q"EXEC sp_detachcb ..."
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
news:17196A2A-FC3F-4B6C-AC32-BF41E842AB48@.microsoft.com...
> Thanks for the reply, but I have no idea what the command lines are for
MSDE
> in order to backup etc. Where would I find those that I need in order to
> backup and then restore to the SQL server?
> Thanks,
> Ken
> "Sylvain Lafontaine" wrote:
> > If they have both the same (and probably latest) service packs, the
> > compatibility is 100% and you don't have to take any special step
(excerpt
> > maybe for authentification and login information). So a Backup/Restore
or a
> > Detach/Reattach operation will be the easiest way.
> >
> > S. L.
> >
> > "Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
> > news:1CE3E73D-87E1-4058-BDAC-5D2FDB3984FE@.microsoft.com...
> > > rI have an end-use that created a database on MSDE and is housing it
on
> > > his local computer. We want to move/copy it to our SQL server so it
> > > can be backed up etc. What are the appropriate steps in doing so?
> > >
> > > Thanks in advance,
> > >
> > > Ken
> > >
> >
> >
> >|||Mr. Aaron,
The problem with this is going to be the users password which Ken needs to
recreate after restoring the db.
v/r
ktf
"Aaron [SQL Server MVP]" wrote:
> Well, look up BACKUP DATABASE in Books Online, and to execute it against
> MSDE, you can use
> osql -S(local)\instancename -E -Q"BACKUP DATABASE ..."
> or
> osql -S(local)\instancename -E -Q"EXEC sp_detachcb ..."
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
> news:17196A2A-FC3F-4B6C-AC32-BF41E842AB48@.microsoft.com...
> > Thanks for the reply, but I have no idea what the command lines are for
> MSDE
> > in order to backup etc. Where would I find those that I need in order to
> > backup and then restore to the SQL server?
> >
> > Thanks,
> >
> > Ken
> >
> > "Sylvain Lafontaine" wrote:
> >
> > > If they have both the same (and probably latest) service packs, the
> > > compatibility is 100% and you don't have to take any special step
> (excerpt
> > > maybe for authentification and login information). So a Backup/Restore
> or a
> > > Detach/Reattach operation will be the easiest way.
> > >
> > > S. L.
> > >
> > > "Ken Gardner" <KenGardner@.discussions.microsoft.com> wrote in message
> > > news:1CE3E73D-87E1-4058-BDAC-5D2FDB3984FE@.microsoft.com...
> > > > rI have an end-use that created a database on MSDE and is housing it
> on
> > > > his local computer. We want to move/copy it to our SQL server so it
> > > > can be backed up etc. What are the appropriate steps in doing so?
> > > >
> > > > Thanks in advance,
> > > >
> > > > Ken
> > > >
> > >
> > >
> > >
>
>|||> The problem with this is going to be the users password which Ken needs to
> recreate after restoring the db.
And he can't do:
osql -S(local)\instancename -E -Q"EXEC sp_password ..."
?
--
http://www.aspfaq.com/
(Reverse address to reply.)

Friday, March 30, 2012

moving...

Monday, March 19, 2012

Moving SQL Server application onto MSDE server

Monday, March 12, 2012

Moving SQL data to another Local Disk

Moving SQL data to another Local Disk

Moving SQL data to another Local Disk

Wednesday, March 7, 2012

moving primary log file

moving primary log file

moving primary log file

Saturday, February 25, 2012

moving MSDE database to SQL...

moving MSDE database to SQL...

moving MSDE database to SQL...

Moving Log Files

Blog Archive

About Me