|
Home > Archive > MS SQL Server > February 2006 > What is the best way to copy a database
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
What is the best way to copy a database
|
|
| David Thielen 2006-02-17, 7:23 am |
| Hi;
I have been reading several articles including
http://www.support.microsoft.com/?id=314546 and there seems to be at least 6
ways to copy a database. Can anyone tell me what the easiest way is?
Both systems are Sql Server 2000 on Windows 2003.
Both are workgroup, not domain systems.
I want to copy the database across including meta data (the comments for
each column), and views.
I have no functions or stored procedures.
I do not want to copy logins across.
What is the easiest way to do this?
--
thanks - dave
david_at_windward_do
t_net
http://www.windwardreports.com
| |
|
| I generally use backup and restore, it's very simple and the only thing you
have to worry about is orphaned users, but since you don't want to copy
logins this will not be a problem for you.
"David Thielen" wrote:
> Hi;
>
> I have been reading several articles including
> http://www.support.microsoft.com/?id=314546 and there seems to be at least 6
> ways to copy a database. Can anyone tell me what the easiest way is?
>
> Both systems are Sql Server 2000 on Windows 2003.
> Both are workgroup, not domain systems.
> I want to copy the database across including meta data (the comments for
> each column), and views.
> I have no functions or stored procedures.
> I do not want to copy logins across.
>
> What is the easiest way to do this?
>
> --
> thanks - dave
> david_at_windward_do
t_net
> http://www.windwardreports.com
>
| |
| Sreejith G 2006-02-17, 7:23 am |
| Depending on the size of DB you have to decide which is the right one from
the list of ways you have. Backup and Restore is good one, if the size is
huge its better to go for attach and detach DB.
Thanks,
Sree
"nost2" wrote:
[color=darkred]
> I generally use backup and restore, it's very simple and the only thing you
> have to worry about is orphaned users, but since you don't want to copy
> logins this will not be a problem for you.
>
> "David Thielen" wrote:
>
| |
| David Thielen 2006-02-17, 9:23 am |
| Worked great - thanks
--
thanks - dave
david_at_windward_do
t_net
http://www.windwardreports.com
"nost2" wrote:
[color=darkred]
> I generally use backup and restore, it's very simple and the only thing you
> have to worry about is orphaned users, but since you don't want to copy
> logins this will not be a problem for you.
>
> "David Thielen" wrote:
>
| |
| Edgardo Valdez, MCSD, MCDBA 2006-02-17, 1:23 pm |
| Depending on the size of the database, you could copy even faster by
detaching, copy the files to the new location and re-attaching them.
It will cut the backup time if the database is big.
"David Thielen" wrote:
> Hi;
>
> I have been reading several articles including
> http://www.support.microsoft.com/?id=314546 and there seems to be at least 6
> ways to copy a database. Can anyone tell me what the easiest way is?
>
> Both systems are Sql Server 2000 on Windows 2003.
> Both are workgroup, not domain systems.
> I want to copy the database across including meta data (the comments for
> each column), and views.
> I have no functions or stored procedures.
> I do not want to copy logins across.
>
> What is the easiest way to do this?
>
> --
> thanks - dave
> david_at_windward_do
t_net
> http://www.windwardreports.com
>
|
|
|
|
|