Automatic Restore

Question

Automatic Restore

mobasha

SSCertifiable

Points: 5334
More actions
May 13, 2008 at 10:23 pm

#190507

Comments posted to this topic are about the item Automatic Restore
..>>..
MobashA

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Rudy Panigas SSChampion Points: 10702 More actions · Answer 1

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

Rudy Panigas SSChampion Points: 10702 More actions · Answer 2

I've fixed the issue.

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

Thanks,

Rudy

mobasha SSCertifiable Points: 5334 More actions · Answer 3

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

Rudy Panigas SSChampion Points: 10702 More actions · Answer 4

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

Thx

Rudy

james davis-441500 SSC Veteran Points: 227 More actions · Answer 5

I am about to test it on my Dev box.. will let you know how it turns out..

btw

thanks for the code..

EllieDBA SSCommitted Points: 1786 More actions · Answer 6

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

amns SSCrazy Points: 2628 More actions · Answer 7

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