Automatic Restore

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by mobasha » Automatic Restore

Automatic Restore

Rate Topic

Display Mode

Topic Options

Author

Message

mobasha

Posted Tuesday, May 13, 2008 10:23 PM

Say 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

Rudy Panigas

Posted Monday, June 23, 2008 10:18 AM

Old Hand

Group: General Forum Members
Last Login: Sunday, May 19, 2013 5:32 PM
Points: 306, Visits: 1,013

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

Rudy Panigas

Posted Monday, June 23, 2008 10:28 AM

Old Hand

Group: General Forum Members
Last Login: Sunday, May 19, 2013 5:32 PM
Points: 306, Visits: 1,013

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

mobasha

Posted Monday, June 23, 2008 3:36 PM

Say 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

Rudy Panigas

Posted Tuesday, June 24, 2008 7:43 AM

Old Hand

Group: General Forum Members
Last Login: Sunday, May 19, 2013 5:32 PM
Points: 306, Visits: 1,013

No problem. Just removed the question marks and it's good.

Thx

Post #522551

james davis-441500

Posted Monday, June 30, 2008 11:54 AM

SSC 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

EllieDBA

Posted Thursday, February 05, 2009 8:30 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, January 04, 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

amns

Posted Tuesday, September 29, 2009 10:54 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 3:16 AM
Points: 103, Visits: 257

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 »

Permissions