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

Automatic Restore Expand / Collapse
Author
Message
Posted Tuesday, May 13, 2008 10:23 PM


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: Sunday, January 29, 2012 1:45 AM
Points: 710, Visits: 1,284
Comments posted to this topic are about the item Automatic Restore

..>>..

MobashA
Post #500168
Posted Monday, June 23, 2008 10:18 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 11:08 AM
Points: 316, Visits: 1,117
Hello,

I like the idea about using your script to restore the database for testing tape backups! There seems to be a strange problem with the code. Copy and paste into SSMS and code looks good, but when saving it the lower half of the code has trailing question mark symbols '???????'. What would cause this and how to correct it?

Thanks,

Rudy



Post #522003
Posted Monday, June 23, 2008 10:28 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 11:08 AM
Points: 316, Visits: 1,117
I've fixed the issue.

Anymore else using this code? I see it has a 5 out of 5 star rating.

Thanks,

Rudy




Post #522015
Posted Monday, June 23, 2008 3:36 PM


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: Sunday, January 29, 2012 1:45 AM
Points: 710, Visits: 1,284
hay sorry about the '???????' but when i past the script i dont know how it has been added, and u can see this case in some script published in the site to.
sorry again.


..>>..

MobashA
Post #522216
Posted Tuesday, June 24, 2008 7:43 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 11:08 AM
Points: 316, Visits: 1,117
No problem. Just removed the question marks and it's good.

Thx



Post #522551
Posted Monday, June 30, 2008 11:54 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 25, 2009 6:26 PM
Points: 27, Visits: 117
I am about to test it on my Dev box.. will let you know how it turns out..
btw
thanks for the code..
Post #526134
Posted Thursday, February 5, 2009 8:30 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 4, 2012 9:40 AM
Points: 54, Visits: 132
Thank you for the help, If I am currently backing up from server A to server B, how can I use this code to make it a schedule task to automatically retore the database on servr B each night overwriting the database?
Thanks a lot
Post #650931
Posted Tuesday, September 29, 2009 10:54 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 3:39 AM
Points: 205, Visits: 455
Hi, i'm trying use this code and i do not have the '?' symbols, i rewrite the code in a new query and continues giving the error
"Incorrect syntax near '?'."

Any ideia?

Thanks in advance
Post #795305
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse