Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Tuesday, November 11, 2014 3:44 AM
Points: 115, Visits: 241
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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 9:30 AM
Points: 509, Visits: 1,885
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: 2, Visits: 3
Thanks for giving this useful information...

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

Add to briefcase

Permissions Expand / Collapse