I am using SQL 2005 std in a cluster configuration.
The problem is running a backup using the maint. plan. I can setup the plan
a schedule the job, however, when the job runs the message I get is
Date 5/12/2006 8:39:01 AM
Log Job History (Maint Plan)
Step ID 1
Server <Server Name>
Job Name Maint Plan
Step Name Subplan
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: <domain name>\sqlsvc. The package execution failed. The
step failed.
I have extended logging turned on but this is the only message I get. I got
this to run once, and that was the first time I setup the plan, I ran it by
right clicking and start job. I have SSIS installed and the SQL agent and
DTC are running.
Thanks for any help.
BrandonDatabase backup errors are logged in the SQL Server Log. Look there for more
information. If the backup was succesfull the information should be there to
o.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Brandon" wrote:
> I am using SQL 2005 std in a cluster configuration.
> The problem is running a backup using the maint. plan. I can setup the pl
an
> a schedule the job, however, when the job runs the message I get is
> Date 5/12/2006 8:39:01 AM
> Log Job History (Maint Plan)
> Step ID 1
> Server <Server Name>
> Job Name Maint Plan
> Step Name Subplan
> Duration 00:00:01
> Sql Severity 0
> Sql Message ID 0
> Operator Emailed
> Operator Net sent
> Operator Paged
> Retries Attempted 0
> Message
> Executed as user: <domain name>\sqlsvc. The package execution failed. The
> step failed.
> I have extended logging turned on but this is the only message I get. I g
ot
> this to run once, and that was the first time I setup the plan, I ran it b
y
> right clicking and start job. I have SSIS installed and the SQL agent and
> DTC are running.
> Thanks for any help.
> Brandon|||I have checked the SQL server log but does not say anything. The only log i
s
in the job log.
"Ben Nevarez" wrote:
[vbcol=seagreen]
> Database backup errors are logged in the SQL Server Log. Look there for mo
re
> information. If the backup was succesfull the information should be there
too.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Brandon" wrote:
>|||I found out the issue. You can not create a manitenance plan from a
workstation, you have to be logged into the server and create it there. Eve
n
more if you have a cluster server the active server needs to be the creator.
If you need to edit the plan it also has to be done from the active server.
If you try to edit it from a workstation it will break.
Brandon
"Brandon" wrote:
[vbcol=seagreen]
> I have checked the SQL server log but does not say anything. The only log
is
> in the job log.
> "Ben Nevarez" wrote:
>
Showing posts with label maint. Show all posts
Showing posts with label maint. Show all posts
Sunday, February 19, 2012
Backup Maintenance Plan
I am using SQL 2005 std in a cluster configuration.
The problem is running a backup using the maint. plan. I can setup the plan
a schedule the job, however, when the job runs the message I get is
Date 5/12/2006 8:39:01 AM
Log Job History (Maint Plan)
Step ID 1
Server <Server Name>
Job Name Maint Plan
Step Name Subplan
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: <domain name>\sqlsvc. The package execution failed. The
step failed.
I have extended logging turned on but this is the only message I get. I got
this to run once, and that was the first time I setup the plan, I ran it by
right clicking and start job. I have SSIS installed and the SQL agent and
DTC are running.
Thanks for any help.
BrandonDatabase backup errors are logged in the SQL Server Log. Look there for more
information. If the backup was succesfull the information should be there too.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Brandon" wrote:
> I am using SQL 2005 std in a cluster configuration.
> The problem is running a backup using the maint. plan. I can setup the plan
> a schedule the job, however, when the job runs the message I get is
> Date 5/12/2006 8:39:01 AM
> Log Job History (Maint Plan)
> Step ID 1
> Server <Server Name>
> Job Name Maint Plan
> Step Name Subplan
> Duration 00:00:01
> Sql Severity 0
> Sql Message ID 0
> Operator Emailed
> Operator Net sent
> Operator Paged
> Retries Attempted 0
> Message
> Executed as user: <domain name>\sqlsvc. The package execution failed. The
> step failed.
> I have extended logging turned on but this is the only message I get. I got
> this to run once, and that was the first time I setup the plan, I ran it by
> right clicking and start job. I have SSIS installed and the SQL agent and
> DTC are running.
> Thanks for any help.
> Brandon|||I have checked the SQL server log but does not say anything. The only log is
in the job log.
"Ben Nevarez" wrote:
> Database backup errors are logged in the SQL Server Log. Look there for more
> information. If the backup was succesfull the information should be there too.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Brandon" wrote:
> > I am using SQL 2005 std in a cluster configuration.
> >
> > The problem is running a backup using the maint. plan. I can setup the plan
> > a schedule the job, however, when the job runs the message I get is
> >
> > Date 5/12/2006 8:39:01 AM
> > Log Job History (Maint Plan)
> >
> > Step ID 1
> > Server <Server Name>
> > Job Name Maint Plan
> > Step Name Subplan
> > Duration 00:00:01
> > Sql Severity 0
> > Sql Message ID 0
> > Operator Emailed
> > Operator Net sent
> > Operator Paged
> > Retries Attempted 0
> >
> > Message
> > Executed as user: <domain name>\sqlsvc. The package execution failed. The
> > step failed.
> >
> > I have extended logging turned on but this is the only message I get. I got
> > this to run once, and that was the first time I setup the plan, I ran it by
> > right clicking and start job. I have SSIS installed and the SQL agent and
> > DTC are running.
> >
> > Thanks for any help.
> > Brandon|||I found out the issue. You can not create a manitenance plan from a
workstation, you have to be logged into the server and create it there. Even
more if you have a cluster server the active server needs to be the creator.
If you need to edit the plan it also has to be done from the active server.
If you try to edit it from a workstation it will break.
Brandon
"Brandon" wrote:
> I have checked the SQL server log but does not say anything. The only log is
> in the job log.
> "Ben Nevarez" wrote:
> >
> > Database backup errors are logged in the SQL Server Log. Look there for more
> > information. If the backup was succesfull the information should be there too.
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "Brandon" wrote:
> >
> > > I am using SQL 2005 std in a cluster configuration.
> > >
> > > The problem is running a backup using the maint. plan. I can setup the plan
> > > a schedule the job, however, when the job runs the message I get is
> > >
> > > Date 5/12/2006 8:39:01 AM
> > > Log Job History (Maint Plan)
> > >
> > > Step ID 1
> > > Server <Server Name>
> > > Job Name Maint Plan
> > > Step Name Subplan
> > > Duration 00:00:01
> > > Sql Severity 0
> > > Sql Message ID 0
> > > Operator Emailed
> > > Operator Net sent
> > > Operator Paged
> > > Retries Attempted 0
> > >
> > > Message
> > > Executed as user: <domain name>\sqlsvc. The package execution failed. The
> > > step failed.
> > >
> > > I have extended logging turned on but this is the only message I get. I got
> > > this to run once, and that was the first time I setup the plan, I ran it by
> > > right clicking and start job. I have SSIS installed and the SQL agent and
> > > DTC are running.
> > >
> > > Thanks for any help.
> > > Brandon
The problem is running a backup using the maint. plan. I can setup the plan
a schedule the job, however, when the job runs the message I get is
Date 5/12/2006 8:39:01 AM
Log Job History (Maint Plan)
Step ID 1
Server <Server Name>
Job Name Maint Plan
Step Name Subplan
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: <domain name>\sqlsvc. The package execution failed. The
step failed.
I have extended logging turned on but this is the only message I get. I got
this to run once, and that was the first time I setup the plan, I ran it by
right clicking and start job. I have SSIS installed and the SQL agent and
DTC are running.
Thanks for any help.
BrandonDatabase backup errors are logged in the SQL Server Log. Look there for more
information. If the backup was succesfull the information should be there too.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Brandon" wrote:
> I am using SQL 2005 std in a cluster configuration.
> The problem is running a backup using the maint. plan. I can setup the plan
> a schedule the job, however, when the job runs the message I get is
> Date 5/12/2006 8:39:01 AM
> Log Job History (Maint Plan)
> Step ID 1
> Server <Server Name>
> Job Name Maint Plan
> Step Name Subplan
> Duration 00:00:01
> Sql Severity 0
> Sql Message ID 0
> Operator Emailed
> Operator Net sent
> Operator Paged
> Retries Attempted 0
> Message
> Executed as user: <domain name>\sqlsvc. The package execution failed. The
> step failed.
> I have extended logging turned on but this is the only message I get. I got
> this to run once, and that was the first time I setup the plan, I ran it by
> right clicking and start job. I have SSIS installed and the SQL agent and
> DTC are running.
> Thanks for any help.
> Brandon|||I have checked the SQL server log but does not say anything. The only log is
in the job log.
"Ben Nevarez" wrote:
> Database backup errors are logged in the SQL Server Log. Look there for more
> information. If the backup was succesfull the information should be there too.
> Ben Nevarez, MCDBA, OCP
> Database Administrator
>
> "Brandon" wrote:
> > I am using SQL 2005 std in a cluster configuration.
> >
> > The problem is running a backup using the maint. plan. I can setup the plan
> > a schedule the job, however, when the job runs the message I get is
> >
> > Date 5/12/2006 8:39:01 AM
> > Log Job History (Maint Plan)
> >
> > Step ID 1
> > Server <Server Name>
> > Job Name Maint Plan
> > Step Name Subplan
> > Duration 00:00:01
> > Sql Severity 0
> > Sql Message ID 0
> > Operator Emailed
> > Operator Net sent
> > Operator Paged
> > Retries Attempted 0
> >
> > Message
> > Executed as user: <domain name>\sqlsvc. The package execution failed. The
> > step failed.
> >
> > I have extended logging turned on but this is the only message I get. I got
> > this to run once, and that was the first time I setup the plan, I ran it by
> > right clicking and start job. I have SSIS installed and the SQL agent and
> > DTC are running.
> >
> > Thanks for any help.
> > Brandon|||I found out the issue. You can not create a manitenance plan from a
workstation, you have to be logged into the server and create it there. Even
more if you have a cluster server the active server needs to be the creator.
If you need to edit the plan it also has to be done from the active server.
If you try to edit it from a workstation it will break.
Brandon
"Brandon" wrote:
> I have checked the SQL server log but does not say anything. The only log is
> in the job log.
> "Ben Nevarez" wrote:
> >
> > Database backup errors are logged in the SQL Server Log. Look there for more
> > information. If the backup was succesfull the information should be there too.
> >
> > Ben Nevarez, MCDBA, OCP
> > Database Administrator
> >
> >
> > "Brandon" wrote:
> >
> > > I am using SQL 2005 std in a cluster configuration.
> > >
> > > The problem is running a backup using the maint. plan. I can setup the plan
> > > a schedule the job, however, when the job runs the message I get is
> > >
> > > Date 5/12/2006 8:39:01 AM
> > > Log Job History (Maint Plan)
> > >
> > > Step ID 1
> > > Server <Server Name>
> > > Job Name Maint Plan
> > > Step Name Subplan
> > > Duration 00:00:01
> > > Sql Severity 0
> > > Sql Message ID 0
> > > Operator Emailed
> > > Operator Net sent
> > > Operator Paged
> > > Retries Attempted 0
> > >
> > > Message
> > > Executed as user: <domain name>\sqlsvc. The package execution failed. The
> > > step failed.
> > >
> > > I have extended logging turned on but this is the only message I get. I got
> > > this to run once, and that was the first time I setup the plan, I ran it by
> > > right clicking and start job. I have SSIS installed and the SQL agent and
> > > DTC are running.
> > >
> > > Thanks for any help.
> > > Brandon
Thursday, February 16, 2012
Backup locations
I need to set up SQL (preferably in a DB Maint Plan) to do scheduled backups, but place them on a mapped drive. (Running out of room on my server!) Whenever I try to set anything up, I can only "see" the local drives. I've tried it mapped and UNC. I've also made sure that both the server's logins appear on both machines and have permissions on the shared folder. What am I missing' Any help would be greatly appreciated
Thanks
TinaMethod 1: Create your maintenance plan and pick an
arbitrary backup directory. When you have finished
creating the plan, go to the Jobs under SQL Server Agent
and modify the DB backup Job for the maintenance plan. The
T-SQL in the job step should be something like:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 1115857B-656B-
4064-9F7A-5BD2C6C1A2E6 -BkUpMedia DISK -
BkUpDB "e:\MSSQLBackup" -BkExt "BAK"'
Change the value following -BkUpDB to a UNC of your choice.
Method 2: Forget about the maintenance plan and create a
SQL Server Agent backup job yourself with the BACKUP
statement. You can then specify whatever UNC you fancy,
assuming there is no permission issue.
Linchi
>--Original Message--
>I need to set up SQL (preferably in a DB Maint Plan) to
do scheduled backups, but place them on a mapped drive.
(Running out of room on my server!) Whenever I try to set
anything up, I can only "see" the local drives. I've tried
it mapped and UNC. I've also made sure that both the
server's logins appear on both machines and have
permissions on the shared folder. What am I missing' Any
help would be greatly appreciated.
>Thanks!
>Tina
>.
>|||Enterprise Mangler will only show local drives. SQL cannot use mapped
drives consistantly because the SQL Service may not see the same mappings as
the console login. The solution is to type the UNC name of the folder in
the target location field.
You also have to make sure that SQL Server can write files to that location.
The easiest way is for you to run SQL under a domain-level account and give
that account permissions on the target folder. Use the following SQL Script
to test access.
xp_cmdshell 'dir \\MyUNCRemote\ShareName'
I suggest giving FULL CONTROL on the target folder to the SQL Service
account. Make sure you have both share permission and underlying NTFS
permissions set correctly.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Tina Tysinger" <ttysinger@.co.hernando.fl.us> wrote in message
news:2D848E29-A745-4682-B70A-D549A2760558@.microsoft.com...
> I need to set up SQL (preferably in a DB Maint Plan) to do scheduled
backups, but place them on a mapped drive. (Running out of room on my
server!) Whenever I try to set anything up, I can only "see" the local
drives. I've tried it mapped and UNC. I've also made sure that both the
server's logins appear on both machines and have permissions on the shared
folder. What am I missing' Any help would be greatly appreciated.
> Thanks!
> Tina
Thanks
TinaMethod 1: Create your maintenance plan and pick an
arbitrary backup directory. When you have finished
creating the plan, go to the Jobs under SQL Server Agent
and modify the DB backup Job for the maintenance plan. The
T-SQL in the job step should be something like:
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 1115857B-656B-
4064-9F7A-5BD2C6C1A2E6 -BkUpMedia DISK -
BkUpDB "e:\MSSQLBackup" -BkExt "BAK"'
Change the value following -BkUpDB to a UNC of your choice.
Method 2: Forget about the maintenance plan and create a
SQL Server Agent backup job yourself with the BACKUP
statement. You can then specify whatever UNC you fancy,
assuming there is no permission issue.
Linchi
>--Original Message--
>I need to set up SQL (preferably in a DB Maint Plan) to
do scheduled backups, but place them on a mapped drive.
(Running out of room on my server!) Whenever I try to set
anything up, I can only "see" the local drives. I've tried
it mapped and UNC. I've also made sure that both the
server's logins appear on both machines and have
permissions on the shared folder. What am I missing' Any
help would be greatly appreciated.
>Thanks!
>Tina
>.
>|||Enterprise Mangler will only show local drives. SQL cannot use mapped
drives consistantly because the SQL Service may not see the same mappings as
the console login. The solution is to type the UNC name of the folder in
the target location field.
You also have to make sure that SQL Server can write files to that location.
The easiest way is for you to run SQL under a domain-level account and give
that account permissions on the target folder. Use the following SQL Script
to test access.
xp_cmdshell 'dir \\MyUNCRemote\ShareName'
I suggest giving FULL CONTROL on the target folder to the SQL Service
account. Make sure you have both share permission and underlying NTFS
permissions set correctly.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Tina Tysinger" <ttysinger@.co.hernando.fl.us> wrote in message
news:2D848E29-A745-4682-B70A-D549A2760558@.microsoft.com...
> I need to set up SQL (preferably in a DB Maint Plan) to do scheduled
backups, but place them on a mapped drive. (Running out of room on my
server!) Whenever I try to set anything up, I can only "see" the local
drives. I've tried it mapped and UNC. I've also made sure that both the
server's logins appear on both machines and have permissions on the shared
folder. What am I missing' Any help would be greatly appreciated.
> Thanks!
> Tina
Sunday, February 12, 2012
backup in maint plan failing
Hello, i'm having a problem with a db backup in a maint plan-- i get an
error saying
Msg 3007, Level 16, State 1, Line 2
The backup of the file or filegroup "sysft_ft" is not permitted because it
is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses
to restrict the selection to include only online data.
Msg 3013, Level 16, State 1, Line 2
What is "sysft_ft"? If i search this in google i literally only get one
hit, which is unbelieveable to me. How can I get around this? I really
don't want to do a file backup and would like to get to the bottom of this.
Thanks, NWOP.This looks like an offline full text catalog. If you are using SQL Server
2005 try
select name, state, state_desc from sys.database_files
If one of the names matchs sysft_ft and state_desc is OFFLINE you will need
to fix it first. Perhaps you just need to rebuild the catalog. After the
catalog is ONLINE you will be able to perform your backup.
Hope this helps,
Ben Nevarez
"new_world_order_pigs" wrote:
> Hello, i'm having a problem with a db backup in a maint plan-- i get an
> error saying
> Msg 3007, Level 16, State 1, Line 2
> The backup of the file or filegroup "sysft_ft" is not permitted because it
> is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses
> to restrict the selection to include only online data.
> Msg 3013, Level 16, State 1, Line 2
> What is "sysft_ft"? If i search this in google i literally only get one
> hit, which is unbelieveable to me. How can I get around this? I really
> don't want to do a file backup and would like to get to the bottom of this.
> Thanks, NWOP.|||Ben,
This did seem to work in that it did put the full text cat back "online" so
I'm assuming that when I run the backup in the evening that it should work
just fine. You are officially a "SQL Server Animal" in my book and I
appreciate your help.
Sincerely,
NWOP.
"Ben Nevarez" wrote:
> This looks like an offline full text catalog. If you are using SQL Server
> 2005 try
> select name, state, state_desc from sys.database_files
> If one of the names matchs sysft_ft and state_desc is OFFLINE you will need
> to fix it first. Perhaps you just need to rebuild the catalog. After the
> catalog is ONLINE you will be able to perform your backup.
> Hope this helps,
> Ben Nevarez
>
>
> "new_world_order_pigs" wrote:
> > Hello, i'm having a problem with a db backup in a maint plan-- i get an
> > error saying
> > Msg 3007, Level 16, State 1, Line 2
> > The backup of the file or filegroup "sysft_ft" is not permitted because it
> > is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses
> > to restrict the selection to include only online data.
> > Msg 3013, Level 16, State 1, Line 2
> >
> > What is "sysft_ft"? If i search this in google i literally only get one
> > hit, which is unbelieveable to me. How can I get around this? I really
> > don't want to do a file backup and would like to get to the bottom of this.
> > Thanks, NWOP.
error saying
Msg 3007, Level 16, State 1, Line 2
The backup of the file or filegroup "sysft_ft" is not permitted because it
is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses
to restrict the selection to include only online data.
Msg 3013, Level 16, State 1, Line 2
What is "sysft_ft"? If i search this in google i literally only get one
hit, which is unbelieveable to me. How can I get around this? I really
don't want to do a file backup and would like to get to the bottom of this.
Thanks, NWOP.This looks like an offline full text catalog. If you are using SQL Server
2005 try
select name, state, state_desc from sys.database_files
If one of the names matchs sysft_ft and state_desc is OFFLINE you will need
to fix it first. Perhaps you just need to rebuild the catalog. After the
catalog is ONLINE you will be able to perform your backup.
Hope this helps,
Ben Nevarez
"new_world_order_pigs" wrote:
> Hello, i'm having a problem with a db backup in a maint plan-- i get an
> error saying
> Msg 3007, Level 16, State 1, Line 2
> The backup of the file or filegroup "sysft_ft" is not permitted because it
> is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses
> to restrict the selection to include only online data.
> Msg 3013, Level 16, State 1, Line 2
> What is "sysft_ft"? If i search this in google i literally only get one
> hit, which is unbelieveable to me. How can I get around this? I really
> don't want to do a file backup and would like to get to the bottom of this.
> Thanks, NWOP.|||Ben,
This did seem to work in that it did put the full text cat back "online" so
I'm assuming that when I run the backup in the evening that it should work
just fine. You are officially a "SQL Server Animal" in my book and I
appreciate your help.
Sincerely,
NWOP.
"Ben Nevarez" wrote:
> This looks like an offline full text catalog. If you are using SQL Server
> 2005 try
> select name, state, state_desc from sys.database_files
> If one of the names matchs sysft_ft and state_desc is OFFLINE you will need
> to fix it first. Perhaps you just need to rebuild the catalog. After the
> catalog is ONLINE you will be able to perform your backup.
> Hope this helps,
> Ben Nevarez
>
>
> "new_world_order_pigs" wrote:
> > Hello, i'm having a problem with a db backup in a maint plan-- i get an
> > error saying
> > Msg 3007, Level 16, State 1, Line 2
> > The backup of the file or filegroup "sysft_ft" is not permitted because it
> > is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses
> > to restrict the selection to include only online data.
> > Msg 3013, Level 16, State 1, Line 2
> >
> > What is "sysft_ft"? If i search this in google i literally only get one
> > hit, which is unbelieveable to me. How can I get around this? I really
> > don't want to do a file backup and would like to get to the bottom of this.
> > Thanks, NWOP.
backup in maint plan failing
Hello, i'm having a problem with a db backup in a maint plan-- i get an
error saying
Msg 3007, Level 16, State 1, Line 2
The backup of the file or filegroup "sysft_ft" is not permitted because it
is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses
to restrict the selection to include only online data.
Msg 3013, Level 16, State 1, Line 2
What is "sysft_ft"? If i search this in google i literally only get one
hit, which is unbelieveable to me. How can I get around this? I really
don't want to do a file backup and would like to get to the bottom of this.
Thanks, NWOP.
This looks like an offline full text catalog. If you are using SQL Server
2005 try
select name, state, state_desc from sys.database_files
If one of the names matchs sysft_ft and state_desc is OFFLINE you will need
to fix it first. Perhaps you just need to rebuild the catalog. After the
catalog is ONLINE you will be able to perform your backup.
Hope this helps,
Ben Nevarez
"new_world_order_pigs" wrote:
> Hello, i'm having a problem with a db backup in a maint plan-- i get an
> error saying
> Msg 3007, Level 16, State 1, Line 2
> The backup of the file or filegroup "sysft_ft" is not permitted because it
> is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses
> to restrict the selection to include only online data.
> Msg 3013, Level 16, State 1, Line 2
> What is "sysft_ft"? If i search this in google i literally only get one
> hit, which is unbelieveable to me. How can I get around this? I really
> don't want to do a file backup and would like to get to the bottom of this.
> Thanks, NWOP.
|||Ben,
This did seem to work in that it did put the full text cat back "online" so
I'm assuming that when I run the backup in the evening that it should work
just fine. You are officially a "SQL Server Animal" in my book and I
appreciate your help.
Sincerely,
NWOP.
"Ben Nevarez" wrote:
[vbcol=seagreen]
> This looks like an offline full text catalog. If you are using SQL Server
> 2005 try
> select name, state, state_desc from sys.database_files
> If one of the names matchs sysft_ft and state_desc is OFFLINE you will need
> to fix it first. Perhaps you just need to rebuild the catalog. After the
> catalog is ONLINE you will be able to perform your backup.
> Hope this helps,
> Ben Nevarez
>
>
> "new_world_order_pigs" wrote:
error saying
Msg 3007, Level 16, State 1, Line 2
The backup of the file or filegroup "sysft_ft" is not permitted because it
is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses
to restrict the selection to include only online data.
Msg 3013, Level 16, State 1, Line 2
What is "sysft_ft"? If i search this in google i literally only get one
hit, which is unbelieveable to me. How can I get around this? I really
don't want to do a file backup and would like to get to the bottom of this.
Thanks, NWOP.
This looks like an offline full text catalog. If you are using SQL Server
2005 try
select name, state, state_desc from sys.database_files
If one of the names matchs sysft_ft and state_desc is OFFLINE you will need
to fix it first. Perhaps you just need to rebuild the catalog. After the
catalog is ONLINE you will be able to perform your backup.
Hope this helps,
Ben Nevarez
"new_world_order_pigs" wrote:
> Hello, i'm having a problem with a db backup in a maint plan-- i get an
> error saying
> Msg 3007, Level 16, State 1, Line 2
> The backup of the file or filegroup "sysft_ft" is not permitted because it
> is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses
> to restrict the selection to include only online data.
> Msg 3013, Level 16, State 1, Line 2
> What is "sysft_ft"? If i search this in google i literally only get one
> hit, which is unbelieveable to me. How can I get around this? I really
> don't want to do a file backup and would like to get to the bottom of this.
> Thanks, NWOP.
|||Ben,
This did seem to work in that it did put the full text cat back "online" so
I'm assuming that when I run the backup in the evening that it should work
just fine. You are officially a "SQL Server Animal" in my book and I
appreciate your help.
Sincerely,
NWOP.
"Ben Nevarez" wrote:
[vbcol=seagreen]
> This looks like an offline full text catalog. If you are using SQL Server
> 2005 try
> select name, state, state_desc from sys.database_files
> If one of the names matchs sysft_ft and state_desc is OFFLINE you will need
> to fix it first. Perhaps you just need to rebuild the catalog. After the
> catalog is ONLINE you will be able to perform your backup.
> Hope this helps,
> Ben Nevarez
>
>
> "new_world_order_pigs" wrote:
Subscribe to:
Posts (Atom)