July 6, 2014 at 1:40 am
I have Restored the Database and we can see that it showing old created date. I have followed below procedure. It will be very helpful if someone provides me the reason.
1) Restored by using restore script.
Note: There is no issue with script. Restored many DB'S by using this.
2) Verified by using sp_helpdb [db_name]
I see the old date i.e of 2012 and Owner is SA. Generally it should be restored date and my self should be owner.
3) By error log i can see that database is restored successfully.
Thanks,
I’m nobody but still I’m somebody to someone………….
July 8, 2014 at 5:33 am
SQLAli (7/6/2014)
2) Verified by using sp_helpdb [db_name]I see the old date i.e of 2012 and Owner is SA. Generally it should be restored date and my self should be owner.
No it shouldn't, it should be the date the database was created, not restored, and who created it, not who restored it.
July 30, 2014 at 6:44 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply