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: Wednesday, July 23, 2014 9:22 PM
Points: 115, Visits: 229
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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, July 25, 2014 2:56 AM
Points: 451, Visits: 1,665
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
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse