Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Filegroup Backups and Restoration

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-10-30 : 08:45:10
Oliver writes "I used the SQL Enterprise Manager to create a job that backs up filegroups. But I have yet to discover how to create a job that restores the filegroups created by the job. I have poured through the Books Online, even copied and pasted the script into the job and modified according to my db structure, to no avail. I get no errors when parsing for syntax, but my script continues to fail. Can anyone please help?"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2002-10-30 : 12:16:22
Please post your script so that we can see what you are doing.

Go to Top of Page

rihardh
Constraint Violating Yak Guru

307 Posts

Posted - 2002-10-30 : 12:35:42
Are you sure that it backs up? Check if SQL server agent is up and running.

Go to Top of Page
   

- Advertisement -