MS SQL Server - Date Created

Author

Date Created

Phil

2005-07-05, 7:23 am

Hi All,

I have recently moved a database from one server to another using the Copy
Database Wizard in Enterprise Manager, all went well, but the database that I
copied from now has has a date created of the same time more or less by the
second as the new one that I put on the new Server, is this a common thing
when using the Wizard?

Thanks in advance!

Wayne Snyder

2005-07-05, 7:23 am

Yes, becuase it simply does a detach/copy/attach, so all of the meta data
should be exactly the same as well.

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.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

"Phil" <Phil@discussions.microsoft.com> wrote in message
news:41F7D7D1-20C0-4CF0-94AB- 72CC34221D0D@microso
ft.com...
> Hi All,
>
> I have recently moved a database from one server to another using the Copy
> Database Wizard in Enterprise Manager, all went well, but the database
> that I
> copied from now has has a date created of the same time more or less by
> the
> second as the new one that I put on the new Server, is this a common thing
> when using the Wizard?
>
> Thanks in advance!

Phil

2005-07-05, 7:23 am

Thanks for that Wayne!

"Wayne Snyder" wrote:

> Yes, becuase it simply does a detach/copy/attach, so all of the meta data
> should be exactly the same as well.
>
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.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
>
> "Phil" <Phil@discussions.microsoft.com> wrote in message
> news:41F7D7D1-20C0-4CF0-94AB- 72CC34221D0D@microso
ft.com...
>
>
>

Sponsored Links