Comments
Sort by recent activity
Hi,
I would be interested in an example of a script that would restore all sqb files from a directory (with the FILELISTONLY option), in my database. I'm only beginning with the sql backup scripting, for the moment.
Actually, i sometime need to restore about 20 base on a new server, and i'm doing this with the sqlbackup GUI witch can only do this one by one [image]
Thanx for the help. / comments
Hi,
I would be interested in an example of a script that would restore all sqb files from a directory (with the FILELISTONLY option), in my database. I'm only beginning with the sql backup scriptin...
thanks, i found the jobs.
When i said that i launch the job manually i used the script generated by the GUI and pasted it in the requete analyzer. But i just launch it with the sql agent and it works too. The job and job steps are activated. I re-actualised the schedule using sql agent, i'll check tomorow if it's ok / comments
thanks, i found the jobs.
When i said that i launch the job manually i used the script generated by the GUI and pasted it in the requete analyzer. But i just launch it with the sql agent and it wor...
I knew that i had to used the sql manager, but can't find where these jobs are stored, and can't find either the sp_delete_job procedure ... [image]
For the schedules task, no error is raised, no log, no erros in the event viewer, nothing. Looks like the task doesn't eaven launch. But when i use the script of this task directly in the sql manager, it works perfectly ..... / comments
I knew that i had to used the sql manager, but can't find where these jobs are stored, and can't find either the sp_delete_job procedure ...
For the schedules task, no error is raised, no log, no ...