Copying Databases From Server to Another

What is the best and safest way to copy about 55 Databases from a server
running win2k to a new server running Win Server 2003 Ent. Ed. What are
the different options do i have? Can I copy all the current Db plans, jobs,
and Logins? What is a good practice for doing this? The win2k server is in
production right now. Do i have to shut it down?
Please Help. Thanks
hi,
"Shash Goyal" <Shash703@.gmail.com> ha scritto nel messaggio
news:uEjQ2LwtEHA.2808@.TK2MSFTNGP14.phx.gbl
> What is the best and safest way to copy about 55 Databases from a
> server running win2k to a new server running Win Server 2003 Ent. Ed.
> What are the different options do i have? Can I copy all the current
> Db plans, jobs, and Logins? What is a good practice for doing this?
> The win2k server is in production right now. Do i have to shut it
> down?
> Please Help. Thanks
wow... a massive task, isn't it? =;-D
I'd suggest, if available, the Copy database wizard, available in Enterprise
Manager, for SQL Server instances, which takes care to move logins and msdb
objects too...
but... if you are on MSDE, you do not have access to it... an all becomes
trickier...
you can perhaps full backup and restore on the new server users databases...
this will not move the logins...
you could then script the logins out and recreate them on the destination
server... keep in mind you will require some login/user sync, as better
explained in
http://www.sqlservercentral.com/colu...okenlogins.asp
as regard msdb objects... script them out too, and recreate tem form their
DDL sql scripts in the destination server...
you are not required to shut down the original server, this way... nor if
you can use Copy database EM wizard... you are required to temporary have
you server down, in someway, if you detach/reattach your user databases...
but I'd prefer the full backup/restore method in this particular scenario..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Thank you Andrea!!!
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:2tpjc9F2386efU1@.uni-berlin.de...
> hi,
> "Shash Goyal" <Shash703@.gmail.com> ha scritto nel messaggio
> news:uEjQ2LwtEHA.2808@.TK2MSFTNGP14.phx.gbl
> wow... a massive task, isn't it? =;-D
> I'd suggest, if available, the Copy database wizard, available in
Enterprise
> Manager, for SQL Server instances, which takes care to move logins and
msdb
> objects too...
> but... if you are on MSDE, you do not have access to it... an all becomes
> trickier...
> you can perhaps full backup and restore on the new server users
databases...
> this will not move the logins...
> you could then script the logins out and recreate them on the destination
> server... keep in mind you will require some login/user sync, as better
> explained in
> http://www.sqlservercentral.com/colu...okenlogins.asp
> as regard msdb objects... script them out too, and recreate tem form their
> DDL sql scripts in the destination server...
> you are not required to shut down the original server, this way... nor if
> you can use Copy database EM wizard... you are required to temporary have
> you server down, in someway, if you detach/reattach your user databases...
> but I'd prefer the full backup/restore method in this particular
scenario..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

copying databases from one server (win2K) to another (win2k3)

Hello All,
I am a SQL server newbie, so please try to answer in simple terms. I
am trying to copy databases from a SQL 2000 (Win2k) to another SQL
2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
getting the familiar "Failed to create OMWWIZE share" error.
I've set up my source server to start up with the 'System Account' and
my destination server to start up with my Windows account that has
administrative privileges on that machine.
After reading up on several froums, SQL Server Books online...I came
to know that backup/restore is a wonderful option, but I don't have
the same drive specifications on the two servers and also need some
step by step instructions on how to back up the databases on the
source server and restore the same in the destination server.
Thanks to you all in advance for the help.
Ram.I think that wizard causes more problems than it solves. Have a look at
these:
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/scr...sp?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.com...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.|||Easiest way is probably to restore a backup to the other server
or detach/attach
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?kbid=314546
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/defaul...b;EN-US;q224071
For tips on using the Copy database wizard
INF: Understanding and Troubleshooting the Copy Database Wizard in SQL
Server 2000
http://support.microsoft.com/defaul...b;en-us;Q274463
Also check out
INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/defaul...b;en-us;Q246133
PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/defaul...b;en-us;Q168001
INF: How to Resolve Permission Issues When a Database is Moved Between SQL
Servers
http://support.microsoft.com/defaul...b;en-us;Q240872
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/defaul...b;en-us;Q274188
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.com...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.

copying databases from one server (win2K) to another (win2k3)

Hello All,
I am a SQL server newbie, so please try to answer in simple terms. I
am trying to copy databases from a SQL 2000 (Win2k) to another SQL
2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
getting the familiar "Failed to create OMWWIZE share" error.
I've set up my source server to start up with the 'System Account' and
my destination server to start up with my Windows account that has
administrative privileges on that machine.
After reading up on several froums, SQL Server Books online...I came
to know that backup/restore is a wonderful option, but I don't have
the same drive specifications on the two servers and also need some
step by step instructions on how to back up the databases on the
source server and restore the same in the destination server.
Thanks to you all in advance for the help.
Ram.I think that wizard causes more problems than it solves. Have a look at
these:
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
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.com...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.|||Easiest way is probably to restore a backup to the other server
or detach/attach
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?kbid=314546
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q224071
For tips on using the Copy database wizard
INF: Understanding and Troubleshooting the Copy Database Wizard in SQL
Server 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274463
Also check out
INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q246133
PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q168001
INF: How to Resolve Permission Issues When a Database is Moved Between SQL
Servers
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q240872
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274188
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.com...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.

copying databases from one server (win2K) to another (win2k3)

Hello All,
I am a SQL server newbie, so please try to answer in simple terms. I
am trying to copy databases from a SQL 2000 (Win2k) to another SQL
2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
getting the familiar "Failed to create OMWWIZE share" error.
I've set up my source server to start up with the 'System Account' and
my destination server to start up with my Windows account that has
administrative privileges on that machine.
After reading up on several froums, SQL Server Books online...I came
to know that backup/restore is a wonderful option, but I don't have
the same drive specifications on the two servers and also need some
step by step instructions on how to back up the databases on the
source server and restore the same in the destination server.
Thanks to you all in advance for the help.
Ram.
I think that wizard causes more problems than it solves. Have a look at
these:
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/scri...p?scriptid=599
Restoring a .mdf
http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles
for SQL Server
http://www.support.microsoft.com/?id=274463 Copy DB Wizard issues
Andrew J. Kelly SQL MVP
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.c om...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.
|||Easiest way is probably to restore a backup to the other server
or detach/attach
HOW TO: Move Databases Between Computers That Are Running SQL Server
http://support.microsoft.com/default.aspx?kbid=314546
INF: Moving SQL Server Databases to a New Location with Detach/Attach
http://support.microsoft.com/default...;EN-US;q224071
For tips on using the Copy database wizard
INF: Understanding and Troubleshooting the Copy Database Wizard in SQL
Server 2000
http://support.microsoft.com/default...;en-us;Q274463
Also check out
INF: How To Transfer Logins and Passwords Between SQL Servers
http://support.microsoft.com/default...;en-us;Q246133
PRB: User Logon and/or Permission Errors After Restoring Dump
http://support.microsoft.com/default...;en-us;Q168001
INF: How to Resolve Permission Issues When a Database is Moved Between SQL
Servers
http://support.microsoft.com/default...;en-us;Q240872
PRB: "Troubleshooting Orphaned Users" Topic in Books Online is Incomplete
http://support.microsoft.com/default...;en-us;Q274188
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"RAM GANESAN" <ramganesan@.gmail.com> wrote in message
news:2dca7102.0407301057.445d4d17@.posting.google.c om...
> Hello All,
> I am a SQL server newbie, so please try to answer in simple terms. I
> am trying to copy databases from a SQL 2000 (Win2k) to another SQL
> 2000 (Win2k3). I am trying to use the Copy Database Wizard and end up
> getting the familiar "Failed to create OMWWIZE share" error.
> I've set up my source server to start up with the 'System Account' and
> my destination server to start up with my Windows account that has
> administrative privileges on that machine.
> After reading up on several froums, SQL Server Books online...I came
> to know that backup/restore is a wonderful option, but I don't have
> the same drive specifications on the two servers and also need some
> step by step instructions on how to back up the databases on the
> source server and restore the same in the destination server.
> Thanks to you all in advance for the help.
> Ram.

Copying Databases

What is the best and safest way to copy about 55 Databases from a server
running win2k to a new server running Win Server 2003 Ent. Ed. What are
the different options do i have? Can I copy all the current Db plans, jobs,
and Logins? What is a good practice for doing this? The win2k server is in
production right now. Do i have to shut it down?
Please Help. Thanks
> What is the best and safest way to copy about 55 Databases from a server
> running win2k to a new server running Win Server 2003 Ent. Ed. What are
> the different options do i have? Can I copy all the current Db plans,
jobs,
> and Logins? What is a good practice for doing this? The win2k server is
in
> production right now. Do i have to shut it down?
Copy Database Wizard in EM is quite nice. You can transfer logins using DTS
Transfer Logins task. For jobs and other things, you can backup and restore
the Msdb database.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
|||It might be worth mentioning that for SQL Server logins, a new SID is generated by CDW. I would
consider skipping that step and handle logins using sp_help_revlogin (search KB).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in message
news:O7%23mgPztEHA.2800@.tk2msftngp13.phx.gbl...
> jobs,
> in
> Copy Database Wizard in EM is quite nice. You can transfer logins using DTS
> Transfer Logins task. For jobs and other things, you can backup and restore
> the Msdb database.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>
|||Thank you all
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OKvNRYztEHA.1048@.tk2msftngp13.phx.gbl...
> It might be worth mentioning that for SQL Server logins, a new SID is
generated by CDW. I would
> consider skipping that step and handle logins using sp_help_revlogin
(search KB).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si > wrote in
message[vbcol=seagreen]
> news:O7%23mgPztEHA.2800@.tk2msftngp13.phx.gbl...
server[vbcol=seagreen]
are[vbcol=seagreen]
is[vbcol=seagreen]
DTS[vbcol=seagreen]
restore
>

Copying Databases

What is the best and safest way to copy about 55 Databases from a server
running win2k to a new server running Win Server 2003 Ent. Ed. What are
the different options do i have? Can I copy all the current Db plans, jobs,
and Logins? What is a good practice for doing this? The win2k server is in
production right now. Do i have to shut it down?
Please Help. Thanks> What is the best and safest way to copy about 55 Databases from a server
> running win2k to a new server running Win Server 2003 Ent. Ed. What are
> the different options do i have? Can I copy all the current Db plans,
jobs,
> and Logins? What is a good practice for doing this? The win2k server is
in
> production right now. Do i have to shut it down?
Copy Database Wizard in EM is quite nice. You can transfer logins using DTS
Transfer Logins task. For jobs and other things, you can backup and restore
the Msdb database.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||It might be worth mentioning that for SQL Server logins, a new SID is generated by CDW. I would
consider skipping that step and handle logins using sp_help_revlogin (search KB).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in message
news:O7%23mgPztEHA.2800@.tk2msftngp13.phx.gbl...
> > What is the best and safest way to copy about 55 Databases from a server
> > running win2k to a new server running Win Server 2003 Ent. Ed. What are
> > the different options do i have? Can I copy all the current Db plans,
> jobs,
> > and Logins? What is a good practice for doing this? The win2k server is
> in
> > production right now. Do i have to shut it down?
> Copy Database Wizard in EM is quite nice. You can transfer logins using DTS
> Transfer Logins task. For jobs and other things, you can backup and restore
> the Msdb database.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>|||Thank you all
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OKvNRYztEHA.1048@.tk2msftngp13.phx.gbl...
> It might be worth mentioning that for SQL Server logins, a new SID is
generated by CDW. I would
> consider skipping that step and handle logins using sp_help_revlogin
(search KB).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message
> news:O7%23mgPztEHA.2800@.tk2msftngp13.phx.gbl...
> > > What is the best and safest way to copy about 55 Databases from a
server
> > > running win2k to a new server running Win Server 2003 Ent. Ed. What
are
> > > the different options do i have? Can I copy all the current Db plans,
> > jobs,
> > > and Logins? What is a good practice for doing this? The win2k server
is
> > in
> > > production right now. Do i have to shut it down?
> >
> > Copy Database Wizard in EM is quite nice. You can transfer logins using
DTS
> > Transfer Logins task. For jobs and other things, you can backup and
restore
> > the Msdb database.
> >
> > --
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > www.SolidQualityLearning.com
> >
> >
>

Copying Databases

What is the best and safest way to copy about 55 Databases from a server
running win2k to a new server running Win Server 2003 Ent. Ed. What are
the different options do i have? Can I copy all the current Db plans, jobs,
and Logins? What is a good practice for doing this? The win2k server is in
production right now. Do i have to shut it down?
Please Help. Thanks> What is the best and safest way to copy about 55 Databases from a server
> running win2k to a new server running Win Server 2003 Ent. Ed. What are
> the different options do i have? Can I copy all the current Db plans,
jobs,
> and Logins? What is a good practice for doing this? The win2k server is
in
> production right now. Do i have to shut it down?
Copy Database Wizard in EM is quite nice. You can transfer logins using DTS
Transfer Logins task. For jobs and other things, you can backup and restore
the Msdb database.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com|||It might be worth mentioning that for SQL Server logins, a new SID is genera
ted by CDW. I would
consider skipping that step and handle logins using sp_help_revlogin (search
KB).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in m
essage
news:O7%23mgPztEHA.2800@.tk2msftngp13.phx.gbl...
> jobs,
> in
> Copy Database Wizard in EM is quite nice. You can transfer logins using DT
S
> Transfer Logins task. For jobs and other things, you can backup and restor
e
> the Msdb database.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
>|||Thank you all
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OKvNRYztEHA.1048@.tk2msftngp13.phx.gbl...
> It might be worth mentioning that for SQL Server logins, a new SID is
generated by CDW. I would
> consider skipping that step and handle logins using sp_help_revlogin
(search KB).
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@.avtenta.si> wrote in
message
> news:O7%23mgPztEHA.2800@.tk2msftngp13.phx.gbl...
server[vbcol=seagreen]
are[vbcol=seagreen]
is[vbcol=seagreen]
DTS[vbcol=seagreen]
restore[vbcol=seagreen]
>

Copying BAK file

When I copy a BACKUP using a .cmd file from a command-box in Win2K, like
this:
copy DBF_db_20040602.BAK .
it copies the entire file to the current directory where the cmd-file is
started.
So far so good...
But, when I change the cmd-file to do this:
copy DBF_db_20040602.BAK DBF_newfile.BAK
is only creates a file of only 6k in size. The original file is about 2 Gb
in size.
Anyone knows why this happens?
..Nico
hi
Have u tried using xcopy?
J
"Nico" <duiken@.nospam.nl> wrote in message
news:40bdeb35$0$136$18b6e80@.news.wanadoo.nl...
> When I copy a BACKUP using a .cmd file from a command-box in Win2K, like
> this:
> copy DBF_db_20040602.BAK .
> it copies the entire file to the current directory where the cmd-file is
> started.
> So far so good...
> But, when I change the cmd-file to do this:
> copy DBF_db_20040602.BAK DBF_newfile.BAK
> is only creates a file of only 6k in size. The original file is about 2 Gb
> in size.
> Anyone knows why this happens?
> .Nico
>
|||Nico,
Sounds strange. I suggest you post this to a windows forum, as likelyhood to find Windows experts should be
higher there... :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nico" <duiken@.nospam.nl> wrote in message news:40bdeb35$0$136$18b6e80@.news.wanadoo.nl...
> When I copy a BACKUP using a .cmd file from a command-box in Win2K, like
> this:
> copy DBF_db_20040602.BAK .
> it copies the entire file to the current directory where the cmd-file is
> started.
> So far so good...
> But, when I change the cmd-file to do this:
> copy DBF_db_20040602.BAK DBF_newfile.BAK
> is only creates a file of only 6k in size. The original file is about 2 Gb
> in size.
> Anyone knows why this happens?
> .Nico
>

Copying BAK file

When I copy a BACKUP using a .cmd file from a command-box in Win2K, like
this:
copy DBF_db_20040602.BAK .
it copies the entire file to the current directory where the cmd-file is
started.
So far so good...
But, when I change the cmd-file to do this:
copy DBF_db_20040602.BAK DBF_newfile.BAK
is only creates a file of only 6k in size. The original file is about 2 Gb
in size.
Anyone knows why this happens?
.Nicohi
Have u tried using xcopy?
J
"Nico" <duiken@.nospam.nl> wrote in message
news:40bdeb35$0$136$18b6e80@.news.wanadoo.nl...
> When I copy a BACKUP using a .cmd file from a command-box in Win2K, like
> this:
> copy DBF_db_20040602.BAK .
> it copies the entire file to the current directory where the cmd-file is
> started.
> So far so good...
> But, when I change the cmd-file to do this:
> copy DBF_db_20040602.BAK DBF_newfile.BAK
> is only creates a file of only 6k in size. The original file is about 2 Gb
> in size.
> Anyone knows why this happens?
> .Nico
>|||Nico,
Sounds strange. I suggest you post this to a windows forum, as likelyhood to
find Windows experts should be
higher there... :-)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nico" <duiken@.nospam.nl> wrote in message news:40bdeb35$0$136$18b6e80@.news.wanadoo.nl...[vb
col=seagreen]
> When I copy a BACKUP using a .cmd file from a command-box in Win2K, like
> this:
> copy DBF_db_20040602.BAK .
> it copies the entire file to the current directory where the cmd-file is
> started.
> So far so good...
> But, when I change the cmd-file to do this:
> copy DBF_db_20040602.BAK DBF_newfile.BAK
> is only creates a file of only 6k in size. The original file is about 2 Gb
> in size.
> Anyone knows why this happens?
> .Nico
>[/vbcol]

Copying BAK file

When I copy a BACKUP using a .cmd file from a command-box in Win2K, like
this:
copy DBF_db_20040602.BAK .
it copies the entire file to the current directory where the cmd-file is
started.
So far so good...
But, when I change the cmd-file to do this:
copy DBF_db_20040602.BAK DBF_newfile.BAK
is only creates a file of only 6k in size. The original file is about 2 Gb
in size.
Anyone knows why this happens?
.Nicohi
Have u tried using xcopy?
J
"Nico" <duiken@.nospam.nl> wrote in message
news:40bdeb35$0$136$18b6e80@.news.wanadoo.nl...
> When I copy a BACKUP using a .cmd file from a command-box in Win2K, like
> this:
> copy DBF_db_20040602.BAK .
> it copies the entire file to the current directory where the cmd-file is
> started.
> So far so good...
> But, when I change the cmd-file to do this:
> copy DBF_db_20040602.BAK DBF_newfile.BAK
> is only creates a file of only 6k in size. The original file is about 2 Gb
> in size.
> Anyone knows why this happens?
> .Nico
>|||Nico,
Sounds strange. I suggest you post this to a windows forum, as likelyhood to find Windows experts should be
higher there... :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Nico" <duiken@.nospam.nl> wrote in message news:40bdeb35$0$136$18b6e80@.news.wanadoo.nl...
> When I copy a BACKUP using a .cmd file from a command-box in Win2K, like
> this:
> copy DBF_db_20040602.BAK .
> it copies the entire file to the current directory where the cmd-file is
> started.
> So far so good...
> But, when I change the cmd-file to do this:
> copy DBF_db_20040602.BAK DBF_newfile.BAK
> is only creates a file of only 6k in size. The original file is about 2 Gb
> in size.
> Anyone knows why this happens?
> .Nico
>