March 4, 2017 at 3:42 pm
Hello,
I did full backup to our 2008 R2 SQL and restore to another 2008 R2 SQL server the only problem I have is that jobs are not in the new server. I thought a fully backup will get me everything. My questions is what why was the jobs not in the new server and what else can be missing. Anybody who can shed me some light I would appreciate. Thank you.
March 4, 2017 at 4:06 pm
what exactly did you backup and restore?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
March 4, 2017 at 5:16 pm
Sorry, database
March 4, 2017 at 5:23 pm
Hi thanks for replying,
I am new to this, but it was a database. What I did was right click database and select tasks and backup. Then I went to the new server and right database and Restore Database. I must have missed a step.
March 5, 2017 at 2:09 am
The jobs are not in the user databases but the msdb system database. The simplest option for transferring them is to generate a create script at the source and apply it on the target server.
😎
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply