Date Created

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!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@.microsoft.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!|||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@.microsoft.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!
>
>