Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Confirmation with Restoration Expand / Collapse
Author
Message
Posted Sunday, July 6, 2014 1:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, February 29, 2016 5:16 AM
Points: 121, Visits: 259
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………….
Post #1589608
Posted Tuesday, July 8, 2014 5:33 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, April 29, 2016 4:01 AM
Points: 697, Visits: 2,730
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.
Post #1590304
Posted Wednesday, July 30, 2014 6:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 31, 2014 1:05 AM
Points: 1, Visits: 3
Thanks for giving this useful information...

SMO Company India
Post #1597691
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse