Backup SQL Server 2005

Hi,

I created a job to backup my database. Sometimes I get the following error:
The job failed. Unable to determine if the owner (DOMAIN\Administrator) of job Backup.Subplan_1 has server access (reason: Could not obtain information about Windows NT group/user 'DOMAIN\Administrator'<c/> error code 0x54b. [SQLSTATE 42000] (Error 15404))

I already deleted the job and made it again. Same problem. I don't get that error every day. For example: I got it 4 times last month.

Does anybody know what I can do to resolve the error?This appears to be a problem with AD. I would guess the job is not able to authenticate itself, or query information from AD. That said, it REALLY a bad idea to run jobs as Domain Admin. You should use service accounts.

Backup Restore Fails

Hi,

I ran a backup procedure and BAK file created.
I moved the file to another server, tried to restore and failed with following error:
"Cannot open backup device 'C:\*****.bak'. Operating system error 5(Access is denied.)"

I checked the file on the original server and the file is accessible: I can see its content with RESTORE FILELISTONLY command.

Any clues?

Thanks,
Mark

Hello Mark

Are you using the Restore dialog to do this operation or are you using T-SQL?

Either case, ensure that the account under which SQL server service is running has access to the 'C' drive.

[Venkat]
This posting is provided "AS IS" with no warranties, and confers no rights.

BackUp master log failed

Hi,
Any one !
I can not create the backup of the master db log.
Is there a restriction on master db log?
thanks in advance
Ed
The master database transaction log, as most system databases, is set to
Simple recovery mode. This negates the ability (or need) to backup the
transaction log.
Jim
"Edward" <Edward@.discussions.microsoft.com> wrote in message
news:898FCAD2-830F-4B79-9E56-5FAFEB3F7320@.microsoft.com...
> Hi,
> Any one !
> I can not create the backup of the master db log.
> Is there a restriction on master db log?
>
> thanks in advance
> Ed

backup maintanence plan failed

Hello,

I created a backup maintanence plan which run good before. I am not sure why it didn't work now.

The error message from job history is:

05/18/2007 09:04:40,backupdbs.backupdbs,Error,0,PEPE\SQL2005PROD,backupdbs.backupdbs,(Job outcome),,The job failed. The Job was invoked by User RMWB3\cs002291. The last step to run was step 1 (backupdbs).,00:00:00,0,0, 0
05/18/2007 09:04:40,backupdbs.backupdbs,Error,1,PEPE\SQL2005PROD,backupdbs.backupdbs,backupdbs,,Unable to start execution of step 1 (reason: line(1): Syntax error). The step failed.,00:00:00,0,0,,,,0

How to debug this problem?

Thanks

Hi,

The actual error should have been logged in the SQL Error Log, please investigate the error log around the time the error occurred.

Jag

|||

I have checked sql agent error log and didn't find any error around that time. Do you mean sql agent error log?

Thanks

|||

i hope this box is a SQL Server 2005 build. In that case , the first thing we check is , whether SP2 applied or not. In sp2 many problems are fixed. If it is not applied, download from Microsoft site and install.

ref ; http://support.microsoft.com/kb/933508

Madhu

|||HI,

Please check the errorlog for that particular time(05/18/2007 09:04:40), you will get the backup error over there. Kindly post the error over here.|||

SQLdba2007,

Please check the SQL Server error rather than SQL agent log.

Jag

|||

There is no error in sql server current log, just no backup info there. There are some errors in sql agent error log .

the error message is:

"unable to read local event log:[reasonarameter is incorrect ] at 12:00am ". my backup maintanence plan start at 11:00pm every day.

I also checked the event log viewer on the box. there are no related errors there and the size is 1.51k.

The DB is sql server 2005 without sp2 applied.

Thanks for all your help!

April

|||

there is no point in trouble shooting this without applying SP2. Service Pack 2 is the minimum requirement to function maintenance plan in SQL Server 2005 and there are many bug fixing done in sp2. So download it and install, it will solve the problem

Madhu

|||

Were you able to resolve this problem? As I have the exact same issue there are no messages in either log file and the error msg displayed is generic. We have installed SP2 and the problem still exists.

|||

The problem is gone after SP2 applied.

Thanks

backup maintanence plan failed

Hello,

I created a backup maintanence plan which run good before. I am not sure why it didn't work now.

The error message from job history is:

05/18/2007 09:04:40,backupdbs.backupdbs,Error,0,PEPE\SQL2005PROD,backupdbs.backupdbs,(Job outcome),,The job failed. The Job was invoked by User RMWB3\cs002291. The last step to run was step 1 (backupdbs).,00:00:00,0,0, 0
05/18/2007 09:04:40,backupdbs.backupdbs,Error,1,PEPE\SQL2005PROD,backupdbs.backupdbs,backupdbs,,Unable to start execution of step 1 (reason: line(1): Syntax error). The step failed.,00:00:00,0,0,,,,0

How to debug this problem?

Thanks

Hi,

The actual error should have been logged in the SQL Error Log, please investigate the error log around the time the error occurred.

Jag

|||

I have checked sql agent error log and didn't find any error around that time. Do you mean sql agent error log?

Thanks

|||

i hope this box is a SQL Server 2005 build. In that case , the first thing we check is , whether SP2 applied or not. In sp2 many problems are fixed. If it is not applied, download from Microsoft site and install.

ref ; http://support.microsoft.com/kb/933508

Madhu

|||HI,

Please check the errorlog for that particular time(05/18/2007 09:04:40), you will get the backup error over there. Kindly post the error over here.|||

SQLdba2007,

Please check the SQL Server error rather than SQL agent log.

Jag

|||

There is no error in sql server current log, just no backup info there. There are some errors in sql agent error log .

the error message is:

"unable to read local event log:[reasonarameter is incorrect ] at 12:00am ". my backup maintanence plan start at 11:00pm every day.

I also checked the event log viewer on the box. there are no related errors there and the size is 1.51k.

The DB is sql server 2005 without sp2 applied.

Thanks for all your help!

April

|||

there is no point in trouble shooting this without applying SP2. Service Pack 2 is the minimum requirement to function maintenance plan in SQL Server 2005 and there are many bug fixing done in sp2. So download it and install, it will solve the problem

Madhu

|||

Were you able to resolve this problem? As I have the exact same issue there are no messages in either log file and the error msg displayed is generic. We have installed SP2 and the problem still exists.

|||

The problem is gone after SP2 applied.

Thanks

BACKUP LOG failed - no reason given

Hello,
I have an agent job that backs up transaction logs of several databases,
referring a maintenance plan.
Recently, one of the backups began to fail sometimes - the one of the
largest database. The messages in the log are:
...
Log backed up: Database: OLAP, creation date(time): 2004/01/21(11:42:56),
first LSN: 4615:16:1, last LSN: 4617:16:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK:
{'D:\MSSQL\MSSQL\BACKUP\OLAP_tlog_200501211015.TRN '}).
Log backed up: Database: RGRSQL, creation date(time): 2004/01/08(10:20:44),
first LSN: 50593:45:1, last LSN: 50614:57:1, number of dump devices: 1,
device information: (FILE=1, TYPE=DISK:
{'D:\MSSQL\MSSQL\BACKUP\RGRSQL_tlog_200501211015.T RN'}).
BACKUP failed to complete the command BACKUP LOG [VMFG] TO DISK =
N'D:\MSSQL\MSSQL\BACKUP\VMFG_tlog_200501211015.TRN ' WITH INIT , NOUNLOAD ,
NOSKIP , STATS = 10, NOFORMAT
MSKB article says to examine the previous errors in the log, but there are
none, neither in sql server log, nor in any event log of the machine.
And then on the next scheduled time, it succeeds. Then again fails. No
pattern.
Pretty much same thing is happening with the full database backup - same
database.
"CHECKDB found 0 allocation errors and 0 consistency errors in database
'VMFG'."
How to troubleshoot it? is there a way to make it to tell _why_ it failed?
thanks,
Vadim Rapp
Polyscience, Inc.
Is someone else trying to put your backup device onto tape while your trying
to write to it?
"Vadim Rapp" <vrapp@.nospam.polyscience.com> wrote in message
news:#6Hq$J#$EHA.2316@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have an agent job that backs up transaction logs of several databases,
> referring a maintenance plan.
> Recently, one of the backups began to fail sometimes - the one of the
> largest database. The messages in the log are:
> ...
> Log backed up: Database: OLAP, creation date(time): 2004/01/21(11:42:56),
> first LSN: 4615:16:1, last LSN: 4617:16:1, number of dump devices: 1,
device
> information: (FILE=1, TYPE=DISK:
> {'D:\MSSQL\MSSQL\BACKUP\OLAP_tlog_200501211015.TRN '}).
> Log backed up: Database: RGRSQL, creation date(time):
2004/01/08(10:20:44),
> first LSN: 50593:45:1, last LSN: 50614:57:1, number of dump devices: 1,
> device information: (FILE=1, TYPE=DISK:
> {'D:\MSSQL\MSSQL\BACKUP\RGRSQL_tlog_200501211015.T RN'}).
> BACKUP failed to complete the command BACKUP LOG [VMFG] TO DISK =
> N'D:\MSSQL\MSSQL\BACKUP\VMFG_tlog_200501211015.TRN ' WITH INIT , NOUNLOAD
,
> NOSKIP , STATS = 10, NOFORMAT
> MSKB article says to examine the previous errors in the log, but there are
> none, neither in sql server log, nor in any event log of the machine.
> And then on the next scheduled time, it succeeds. Then again fails. No
> pattern.
> Pretty much same thing is happening with the full database backup - same
> database.
> "CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'VMFG'."
> How to troubleshoot it? is there a way to make it to tell _why_ it failed?
>
> thanks,
> Vadim Rapp
> Polyscience, Inc.
>
>
|||Hello Chris:
You wrote on Fri, 21 Jan 2005 11:09:20 -0800:
C> Is someone else trying to put your backup device onto tape while your
C> trying to write to it?
No.
Vadim

BACKUP LOG failed - no reason given

Hello,
I have an agent job that backs up transaction logs of several databases,
referring a maintenance plan.
Recently, one of the backups began to fail sometimes - the one of the
largest database. The messages in the log are:
...
Log backed up: Database: OLAP, creation date(time): 2004/01/21(11:42:56),
first LSN: 4615:16:1, last LSN: 4617:16:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK:
{'D:\MSSQL\MSSQL\BACKUP\OLAP_tlog_200501211015.TRN'}).
Log backed up: Database: RGRSQL, creation date(time): 2004/01/08(10:20:44),
first LSN: 50593:45:1, last LSN: 50614:57:1, number of dump devices: 1,
device information: (FILE=1, TYPE=DISK:
{'D:\MSSQL\MSSQL\BACKUP\RGRSQL_tlog_200501211015.TRN'}).
BACKUP failed to complete the command BACKUP LOG [VMFG] TO DISK = N'D:\MSSQL\MSSQL\BACKUP\VMFG_tlog_200501211015.TRN' WITH INIT , NOUNLOAD ,
NOSKIP , STATS = 10, NOFORMAT
MSKB article says to examine the previous errors in the log, but there are
none, neither in sql server log, nor in any event log of the machine.
And then on the next scheduled time, it succeeds. Then again fails. No
pattern.
Pretty much same thing is happening with the full database backup - same
database.
"CHECKDB found 0 allocation errors and 0 consistency errors in database
'VMFG'."
How to troubleshoot it? is there a way to make it to tell _why_ it failed?
thanks,
Vadim Rapp
Polyscience, Inc.Is someone else trying to put your backup device onto tape while your trying
to write to it?
"Vadim Rapp" <vrapp@.nospam.polyscience.com> wrote in message
news:#6Hq$J#$EHA.2316@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have an agent job that backs up transaction logs of several databases,
> referring a maintenance plan.
> Recently, one of the backups began to fail sometimes - the one of the
> largest database. The messages in the log are:
> ...
> Log backed up: Database: OLAP, creation date(time): 2004/01/21(11:42:56),
> first LSN: 4615:16:1, last LSN: 4617:16:1, number of dump devices: 1,
device
> information: (FILE=1, TYPE=DISK:
> {'D:\MSSQL\MSSQL\BACKUP\OLAP_tlog_200501211015.TRN'}).
> Log backed up: Database: RGRSQL, creation date(time):
2004/01/08(10:20:44),
> first LSN: 50593:45:1, last LSN: 50614:57:1, number of dump devices: 1,
> device information: (FILE=1, TYPE=DISK:
> {'D:\MSSQL\MSSQL\BACKUP\RGRSQL_tlog_200501211015.TRN'}).
> BACKUP failed to complete the command BACKUP LOG [VMFG] TO DISK => N'D:\MSSQL\MSSQL\BACKUP\VMFG_tlog_200501211015.TRN' WITH INIT , NOUNLOAD
,
> NOSKIP , STATS = 10, NOFORMAT
> MSKB article says to examine the previous errors in the log, but there are
> none, neither in sql server log, nor in any event log of the machine.
> And then on the next scheduled time, it succeeds. Then again fails. No
> pattern.
> Pretty much same thing is happening with the full database backup - same
> database.
> "CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'VMFG'."
> How to troubleshoot it? is there a way to make it to tell _why_ it failed?
>
> thanks,
> Vadim Rapp
> Polyscience, Inc.
>
>|||Hello Chris:
You wrote on Fri, 21 Jan 2005 11:09:20 -0800:
C> Is someone else trying to put your backup device onto tape while your
C> trying to write to it?
No.
Vadim

BACKUP LOG failed - no reason given

Hello,
I have an agent job that backs up transaction logs of several databases,
referring a maintenance plan.
Recently, one of the backups began to fail sometimes - the one of the
largest database. The messages in the log are:
...
Log backed up: Database: OLAP, creation date(time): 2004/01/21(11:42:56),
first LSN: 4615:16:1, last LSN: 4617:16:1, number of dump devices: 1, device
information: (FILE=1, TYPE=DISK:
& #123;'D:\MSSQL\MSSQL\BACKUP\OLAP_tlog_20
0501211015.TRN'}).
Log backed up: Database: RGRSQL, creation date(time): 2004/01/08(10:20:44),
first LSN: 50593:45:1, last LSN: 50614:57:1, number of dump devices: 1,
device information: (FILE=1, TYPE=DISK:
& #123;'D:\MSSQL\MSSQL\BACKUP\RGRSQL_tlog_
200501211015.TRN'}).
BACKUP failed to complete the command BACKUP LOG [VMFG] TO DISK =
N'D:\MSSQL\MSSQL\BACKUP\VMFG_tlog_200501
211015.TRN' WITH INIT , NOUNLOAD ,
NOSKIP , STATS = 10, NOFORMAT
MSKB article says to examine the previous errors in the log, but there are
none, neither in sql server log, nor in any event log of the machine.
And then on the next scheduled time, it succeeds. Then again fails. No
pattern.
Pretty much same thing is happening with the full database backup - same
database.
"CHECKDB found 0 allocation errors and 0 consistency errors in database
'VMFG'."
How to troubleshoot it? is there a way to make it to tell _why_ it failed?
thanks,
Vadim Rapp
Polyscience, Inc.Is someone else trying to put your backup device onto tape while your trying
to write to it?
"Vadim Rapp" <vrapp@.nospam.polyscience.com> wrote in message
news:#6Hq$J#$EHA.2316@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have an agent job that backs up transaction logs of several databases,
> referring a maintenance plan.
> Recently, one of the backups began to fail sometimes - the one of the
> largest database. The messages in the log are:
> ...
> Log backed up: Database: OLAP, creation date(time): 2004/01/21(11:42:56),
> first LSN: 4615:16:1, last LSN: 4617:16:1, number of dump devices: 1,
device
> information: (FILE=1, TYPE=DISK:
> & #123;'D:\MSSQL\MSSQL\BACKUP\OLAP_tlog_20
0501211015.TRN'}).
> Log backed up: Database: RGRSQL, creation date(time):
2004/01/08(10:20:44),
> first LSN: 50593:45:1, last LSN: 50614:57:1, number of dump devices: 1,
> device information: (FILE=1, TYPE=DISK:
> & #123;'D:\MSSQL\MSSQL\BACKUP\RGRSQL_tlog_
200501211015.TRN'}).
> BACKUP failed to complete the command BACKUP LOG [VMFG] TO DISK =
> N'D:\MSSQL\MSSQL\BACKUP\VMFG_tlog_200501
211015.TRN' WITH INIT , NOUNLOAD
,
> NOSKIP , STATS = 10, NOFORMAT
> MSKB article says to examine the previous errors in the log, but there are
> none, neither in sql server log, nor in any event log of the machine.
> And then on the next scheduled time, it succeeds. Then again fails. No
> pattern.
> Pretty much same thing is happening with the full database backup - same
> database.
> "CHECKDB found 0 allocation errors and 0 consistency errors in database
> 'VMFG'."
> How to troubleshoot it? is there a way to make it to tell _why_ it failed?
>
> thanks,
> Vadim Rapp
> Polyscience, Inc.
>
>|||Hello Chris:
You wrote on Fri, 21 Jan 2005 11:09:20 -0800:
C> Is someone else trying to put your backup device onto tape while your
C> trying to write to it?
No.
Vadim

Backup Job Notification Error

I continue to receive a message alert that my backup job
failed for three of my servers every morning while in the
real sense the backups completed successfully. I did
reboot one of the servers but this did not reslove the
issue. Any help on this will be appreaciated please.Are these databases in Simple recovery mode? If so, any
transaction log backup will fail, and a SQL Maintenance
Plan will show an overall failure to execute (although the
full backups will run).
Also, have you tried restoring one of the backups that
completed? Another thing to check is to make sure the job
doesn't have additional steps, or operator alerts, or any
of the optional settings on. If execution of any of the
other activities should occur, overall failure of the job
may be flagged.
Also, in the job history, what is the exact error you're
receiving -- that is, when the Show Details option is
checked?
>--Original Message--
>I continue to receive a message alert that my backup job
>failed for three of my servers every morning while in the
>real sense the backups completed successfully. I did
>reboot one of the servers but this did not reslove the
>issue. Any help on this will be appreaciated please.
>.
>|||here is the error message. any new lead.
The job failed. The Job was invoked by Schedule 7
(Schedule 1). The last step to run was step 1 (Step 1).
Thanks,
Aboki.
>--Original Message--
>Are these databases in Simple recovery mode? If so, any
>transaction log backup will fail, and a SQL Maintenance
>Plan will show an overall failure to execute (although
the
>full backups will run).
>Also, have you tried restoring one of the backups that
>completed? Another thing to check is to make sure the
job
>doesn't have additional steps, or operator alerts, or any
>of the optional settings on. If execution of any of the
>other activities should occur, overall failure of the job
>may be flagged.
>Also, in the job history, what is the exact error you're
>receiving -- that is, when the Show Details option is
>checked?
>>--Original Message--
>>I continue to receive a message alert that my backup job
>>failed for three of my servers every morning while in
the
>>real sense the backups completed successfully. I did
>>reboot one of the servers but this did not reslove the
>>issue. Any help on this will be appreaciated please.
>>.
>.
>|||Here are the details when show step details is selected.
Executed as user: BHCS\sqlsrv. sqlmaint.exe failed.
[SQLSTATE 42000] (Error 22029). The step failed.
The job failed. The Job was invoked by Schedule 7
(Schedule 1). The last step to run was step 1 (Step 1).
Thanks,
Aboki.
>--Original Message--
>here is the error message. any new lead.
>The job failed. The Job was invoked by Schedule 7
>(Schedule 1). The last step to run was step 1 (Step 1).
>
>Thanks,
>Aboki.
>
>>--Original Message--
>>Are these databases in Simple recovery mode? If so, any
>>transaction log backup will fail, and a SQL Maintenance
>>Plan will show an overall failure to execute (although
>the
>>full backups will run).
>>Also, have you tried restoring one of the backups that
>>completed? Another thing to check is to make sure the
>job
>>doesn't have additional steps, or operator alerts, or
any
>>of the optional settings on. If execution of any of the
>>other activities should occur, overall failure of the
job
>>may be flagged.
>>Also, in the job history, what is the exact error you're
>>receiving -- that is, when the Show Details option is
>>checked?
>>--Original Message--
>>I continue to receive a message alert that my backup
job
>>failed for three of my servers every morning while in
>the
>>real sense the backups completed successfully. I did
>>reboot one of the servers but this did not reslove the
>>issue. Any help on this will be appreaciated please.
>>.
>>.
>.
>|||Check to ensure it is the backup step which is failing... Often the step
PRIOR to backup fails... That would be doing the DBCC and having selected
"Repair" option.. This option requires the db to be in single-user mode. If
users are in the db, this step fails...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Aboki" <hcokoli@.yahoo.com> wrote in message
news:426301c4731f$6ac87900$a401280a@.phx.gbl...
> I continue to receive a message alert that my backup job
> failed for three of my servers every morning while in the
> real sense the backups completed successfully. I did
> reboot one of the servers but this did not reslove the
> issue. Any help on this will be appreaciated please.

backup job

I have set up a scheduled backup job and the owner is set to john. The
scheduled backup job always failed no matter it manually run or scheduled. I
use query analyzer and login as john and copy the script from the job and
execute it and IT RUN. OK, I change the job owner to sa and it runs. Can
anyone please tell me why the job run in query analyzer but not in Enterprse
Manager and how to fix it? Thanks.
What job step type? Is John an SQL Server or a Windows login? What exact error for the job? If you
define an output file for the jobstep, what error(s) do you see there?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
" -00Eric Clapton" <a@.b.com> wrote in message news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>I have set up a scheduled backup job and the owner is set to john. The scheduled backup job always
>failed no matter it manually run or scheduled. I use query analyzer and login as john and copy the
>script from the job and execute it and IT RUN. OK, I change the job owner to sa and it runs. Can
>anyone please tell me why the job run in query analyzer but not in Enterprse Manager and how to fix
>it? Thanks.
>
|||John is a SQL Server login and no windows login and it is assigned as system
administrator role in SQL server. When I looked at the job log in EM, it
said "failed to run at certain time". Please help. Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
> What job step type? Is John an SQL Server or a Windows login? What exact
> error for the job? If you define an output file for the jobstep, what
> error(s) do you see there?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> " -00Eric Clapton" <a@.b.com> wrote in message
> news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>
|||This is what I got from output file:
************************************************** ************************
Job 'pure backup - wed' : Step 1, 'Step 1' : Began Executing 2005-12-08
09:28:00
Msg 916, Sev 14: Server user 'guest' is not a valid user in database 'pure'.
[SQLSTATE 08004]
Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE
42000]
************************************************** *********************************
pure is the database I want to backup. The strange things I realized is that
John is the owner of the scheduled job but why guest user is involved in the
scheduled job according to the output file. Can you please help? Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
> What job step type? Is John an SQL Server or a Windows login? What exact
> error for the job? If you define an output file for the jobstep, what
> error(s) do you see there?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> " -00Eric Clapton" <a@.b.com> wrote in message
> news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>
|||So it is a TSQL job step. What database is it defined to run in? Make sure it runs in the master
database and do *not* perform USE within the TSQL code. Always do your BACKUP and RESTORE from the
master database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
" -00Eric Clapton" <a@.b.com> wrote in message news:e7sxP35%23FHA.3908@.TK2MSFTNGP10.phx.gbl...
> This is what I got from output file:
> ************************************************** ************************
> Job 'pure backup - wed' : Step 1, 'Step 1' : Began Executing 2005-12-08 09:28:00
> Msg 916, Sev 14: Server user 'guest' is not a valid user in database 'pure'. [SQLSTATE 08004]
> Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000]
> ************************************************** *********************************
> pure is the database I want to backup. The strange things I realized is that John is the owner of
> the scheduled job but why guest user is involved in the scheduled job according to the output
> file. Can you please help? Thanks.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
>

backup job

I have set up a scheduled backup job and the owner is set to john. The
scheduled backup job always failed no matter it manually run or scheduled. I
use query analyzer and login as john and copy the script from the job and
execute it and IT RUN. OK, I change the job owner to sa and it runs. Can
anyone please tell me why the job run in query analyzer but not in Enterprse
Manager and how to fix it? Thanks.What job step type? Is John an SQL Server or a Windows login? What exact error for the job? If you
define an output file for the jobstep, what error(s) do you see there?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
" -00Eric Clapton" <a@.b.com> wrote in message news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>I have set up a scheduled backup job and the owner is set to john. The scheduled backup job always
>failed no matter it manually run or scheduled. I use query analyzer and login as john and copy the
>script from the job and execute it and IT RUN. OK, I change the job owner to sa and it runs. Can
>anyone please tell me why the job run in query analyzer but not in Enterprse Manager and how to fix
>it? Thanks.
>|||John is a SQL Server login and no windows login and it is assigned as system
administrator role in SQL server. When I looked at the job log in EM, it
said "failed to run at certain time". Please help. Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
> What job step type? Is John an SQL Server or a Windows login? What exact
> error for the job? If you define an output file for the jobstep, what
> error(s) do you see there?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> " -00Eric Clapton" <a@.b.com> wrote in message
> news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>>I have set up a scheduled backup job and the owner is set to john. The
>>scheduled backup job always failed no matter it manually run or scheduled.
>>I use query analyzer and login as john and copy the script from the job
>>and execute it and IT RUN. OK, I change the job owner to sa and it runs.
>>Can anyone please tell me why the job run in query analyzer but not in
>>Enterprse Manager and how to fix it? Thanks.
>|||This is what I got from output file:
**************************************************************************
Job 'pure backup - wed' : Step 1, 'Step 1' : Began Executing 2005-12-08
09:28:00
Msg 916, Sev 14: Server user 'guest' is not a valid user in database 'pure'.
[SQLSTATE 08004]
Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE
42000]
***********************************************************************************
pure is the database I want to backup. The strange things I realized is that
John is the owner of the scheduled job but why guest user is involved in the
scheduled job according to the output file. Can you please help? Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
> What job step type? Is John an SQL Server or a Windows login? What exact
> error for the job? If you define an output file for the jobstep, what
> error(s) do you see there?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> " -00Eric Clapton" <a@.b.com> wrote in message
> news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>>I have set up a scheduled backup job and the owner is set to john. The
>>scheduled backup job always failed no matter it manually run or scheduled.
>>I use query analyzer and login as john and copy the script from the job
>>and execute it and IT RUN. OK, I change the job owner to sa and it runs.
>>Can anyone please tell me why the job run in query analyzer but not in
>>Enterprse Manager and how to fix it? Thanks.
>|||So it is a TSQL job step. What database is it defined to run in? Make sure it runs in the master
database and do *not* perform USE within the TSQL code. Always do your BACKUP and RESTORE from the
master database.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
" -00Eric Clapton" <a@.b.com> wrote in message news:e7sxP35%23FHA.3908@.TK2MSFTNGP10.phx.gbl...
> This is what I got from output file:
> **************************************************************************
> Job 'pure backup - wed' : Step 1, 'Step 1' : Began Executing 2005-12-08 09:28:00
> Msg 916, Sev 14: Server user 'guest' is not a valid user in database 'pure'. [SQLSTATE 08004]
> Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000]
> ***********************************************************************************
> pure is the database I want to backup. The strange things I realized is that John is the owner of
> the scheduled job but why guest user is involved in the scheduled job according to the output
> file. Can you please help? Thanks.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
>> What job step type? Is John an SQL Server or a Windows login? What exact error for the job? If
>> you define an output file for the jobstep, what error(s) do you see there?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>> Blog: http://solidqualitylearning.com/blogs/tibor/
>>
>> " -00Eric Clapton" <a@.b.com> wrote in message news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>>I have set up a scheduled backup job and the owner is set to john. The scheduled backup job
>>always failed no matter it manually run or scheduled. I use query analyzer and login as john and
>>copy the script from the job and execute it and IT RUN. OK, I change the job owner to sa and it
>>runs. Can anyone please tell me why the job run in query analyzer but not in Enterprse Manager
>>and how to fix it? Thanks.
>>
>

Backup job

hello everyone, I have a backup maintenance job running on
my server, it is showing the failed prompt, but when i
checked the log it is showing the database backed up
successfully..
What can i do to get rid of the failed status and what may
be causing this'
Thank you
ATI've seen it because it is trying to fix indexes while users are online and
using them. Set the index optimizations in seperate plans than your backups
to make the errors more clear.
Christian Smith
"AT" <adigga3@.hotmail.com> wrote in message
news:e4a601c3f015$ff272200$a601280a@.phx.gbl...
> hello everyone, I have a backup maintenance job running on
> my server, it is showing the failed prompt, but when i
> checked the log it is showing the database backed up
> successfully..
> What can i do to get rid of the failed status and what may
> be causing this'
> Thank you
> AT|||Thanks Christian, but the backup job still shows that it
backed up when I look at log or history files. will this
be a problem? how do i clear the "Red X" sign that appears?
>--Original Message--
>I've seen it because it is trying to fix indexes while
users are online and
>using them. Set the index optimizations in seperate
plans than your backups
>to make the errors more clear.
>Christian Smith
>"AT" <adigga3@.hotmail.com> wrote in message
>news:e4a601c3f015$ff272200$a601280a@.phx.gbl...
>> hello everyone, I have a backup maintenance job running
on
>> my server, it is showing the failed prompt, but when i
>> checked the log it is showing the database backed up
>> successfully..
>> What can i do to get rid of the failed status and what
may
>> be causing this'
>> Thank you
>> AT
>
>.
>|||Specify a report file for the maint job and check for the real error message
in that report file.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"AT" <anonymous@.discussions.microsoft.com> wrote in message
news:e5df01c3f02a$e895cd10$a601280a@.phx.gbl...
> Thanks Christian, but the backup job still shows that it
> backed up when I look at log or history files. will this
> be a problem? how do i clear the "Red X" sign that appears?
> >--Original Message--
> >I've seen it because it is trying to fix indexes while
> users are online and
> >using them. Set the index optimizations in seperate
> plans than your backups
> >to make the errors more clear.
> >
> >Christian Smith
> >
> >"AT" <adigga3@.hotmail.com> wrote in message
> >news:e4a601c3f015$ff272200$a601280a@.phx.gbl...
> >> hello everyone, I have a backup maintenance job running
> on
> >> my server, it is showing the failed prompt, but when i
> >> checked the log it is showing the database backed up
> >> successfully..
> >> What can i do to get rid of the failed status and what
> may
> >> be causing this'
> >>
> >> Thank you
> >> AT
> >
> >
> >.
> >

backup job

I have set up a scheduled backup job and the owner is set to john. The
scheduled backup job always failed no matter it manually run or scheduled. I
use query analyzer and login as john and copy the script from the job and
execute it and IT RUN. OK, I change the job owner to sa and it runs. Can
anyone please tell me why the job run in query analyzer but not in Enterprse
Manager and how to fix it? Thanks.What job step type? Is John an SQL Server or a Windows login? What exact err
or for the job? If you
define an output file for the jobstep, what error(s) do you see there?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
" -00Eric Clapton" <a@.b.com> wrote in message news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl
..
>I have set up a scheduled backup job and the owner is set to john. The sch
eduled backup job always
>failed no matter it manually run or scheduled. I use query analyzer and log
in as john and copy the
>script from the job and execute it and IT RUN. OK, I change the job owner
to sa and it runs. Can
>anyone please tell me why the job run in query analyzer but not in Enterprs
e Manager and how to fix
>it? Thanks.
>|||John is a SQL Server login and no windows login and it is assigned as system
administrator role in SQL server. When I looked at the job log in EM, it
said "failed to run at certain time". Please help. Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
> What job step type? Is John an SQL Server or a Windows login? What exact
> error for the job? If you define an output file for the jobstep, what
> error(s) do you see there?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> " -00Eric Clapton" <a@.b.com> wrote in message
> news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>|||This is what I got from output file:
****************************************
**********************************
Job 'pure backup - wed' : Step 1, 'Step 1' : Began Executing 2005-12-08
09:28:00
Msg 916, Sev 14: Server user 'guest' is not a valid user in database 'pure'.
[SQLSTATE 08004]
Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE
42000]
****************************************
************************************
*******
pure is the database I want to backup. The strange things I realized is that
John is the owner of the scheduled job but why guest user is involved in the
scheduled job according to the output file. Can you please help? Thanks.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
> What job step type? Is John an SQL Server or a Windows login? What exact
> error for the job? If you define an output file for the jobstep, what
> error(s) do you see there?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> " -00Eric Clapton" <a@.b.com> wrote in message
> news:OZ%235Egv%23FHA.3464@.TK2MSFTNGP15.phx.gbl...
>|||So it is a TSQL job step. What database is it defined to run in? Make sure i
t runs in the master
database and do *not* perform USE within the TSQL code. Always do your BACKU
P and RESTORE from the
master database.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
" -00Eric Clapton" <a@.b.com> wrote in message news:e7sxP35%23FHA.3908@.TK2MSFTNGP10.phx.gbl..
.
> This is what I got from output file:
> ****************************************
**********************************
> Job 'pure backup - wed' : Step 1, 'Step 1' : Began Executing 2005-12-08 09
:28:00
> Msg 916, Sev 14: Server user 'guest' is not a valid user in database 'pure
'. [SQLSTATE 08004]
> Msg 3013, Sev 16: BACKUP DATABASE is terminating abnormally. [SQLSTATE
42000]
> ****************************************
**********************************
*********
> pure is the database I want to backup. The strange things I realized is th
at John is the owner of
> the scheduled job but why guest user is involved in the scheduled job acco
rding to the output
> file. Can you please help? Thanks.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:ec3rqi4%23FHA.344@.TK2MSFTNGP11.phx.gbl...
>

Backup job

hello everyone, I have a backup maintenance job running on
my server, it is showing the failed prompt, but when i
checked the log it is showing the database backed up
successfully..
What can i do to get rid of the failed status and what may
be causing this'
Thank you
ATI've seen it because it is trying to fix indexes while users are online and
using them. Set the index optimizations in seperate plans than your backups
to make the errors more clear.
Christian Smith
"AT" <adigga3@.hotmail.com> wrote in message
news:e4a601c3f015$ff272200$a601280a@.phx.gbl...
> hello everyone, I have a backup maintenance job running on
> my server, it is showing the failed prompt, but when i
> checked the log it is showing the database backed up
> successfully..
> What can i do to get rid of the failed status and what may
> be causing this'
> Thank you
> AT|||Thanks Christian, but the backup job still shows that it
backed up when I look at log or history files. will this
be a problem? how do i clear the "Red X" sign that appears?
>--Original Message--
>I've seen it because it is trying to fix indexes while
users are online and
>using them. Set the index optimizations in seperate
plans than your backups
>to make the errors more clear.
>Christian Smith
>"AT" <adigga3@.hotmail.com> wrote in message
>news:e4a601c3f015$ff272200$a601280a@.phx.gbl...
on
may
>
>.
>|||Specify a report file for the maint job and check for the real error message
in that report file.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"AT" <anonymous@.discussions.microsoft.com> wrote in message
news:e5df01c3f02a$e895cd10$a601280a@.phx.gbl...
> Thanks Christian, but the backup job still shows that it
> backed up when I look at log or history files. will this
> be a problem? how do i clear the "Red X" sign that appears?
> users are online and
> plans than your backups
> on
> may

Backup issuesPlease HEELP!

I am trying to run a backup job and it has fail the message I am getting is:

The job failed. Unable to determine if the owner (MAMSI\lwilliams) of job DB Backup Job for DB Maintenance Plan 'DB Maintenance Plan1' has server access (reason: Could not obtain information about Windows NT group/user 'MAMSI\lwilliams'. [SQLSTATE 42000] (Error 8198)).

Is it stating that my user group in windows NT doesn't have the rights to run a backup on this server?

Please help!!!

LystraMy first guess would be that the account used to start the SQL Agent service isn't a domain admin, so the agent can't even see what permissions the MAMSI\lwilliams login has in the domain.

NT security is a tough nut to crack at first, mostly because there are so many levels to it. This makes it robust, but a bugger to figure out at first!

-PatP

Backup issues

I am very new to SQL Express. A database is located on a local machine. When I try to do a backup I get the following error:

Backup failed for server ‘server name’

(Microsoft.sql server.Express.smo)

Additional information:

Set property Devices to accomplish this action.

(Microsoft.sql server.Express.smo)

Their IT tecnicians insits that I have full administrative rights.

I am lost for a solution.

Would it be wise to shrink the database, detach from the database and copy both the mdf and idf to a different machine? I have never done this procedure before.

Please help.

Could you please send over the executed script ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||I am having same problem.
I am connected to sql server 2000 instance.
When trying to backup the database i got the same error
Any idea why ?|||

Which Gui are you using ?

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||Sql Server Management Studio|||

Could you please then post the resulting Backup SQL command which is available through the script functionality within the Backup UI.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Did anyone get a resolution to this? I'm having the same problem. I uninstalled and reinstalled SQL Server 2005 Express and then reinstalled and it worked fine. I was able to back up the database for two days. Then the error started coming up again and now I'm getting the "Set property Devices to accomplish this action." error again.

I have no clue what property device it's talking about or where to set them. Any help would be greatly appreciated!

Thanks,

Steve

Backup issues

Hi there
My SQL server backups are running as nicely as they used to. Recently I
got the following error:
Message: The job failed. The owner () of job DB Backup Job for DB
Maintenance Plan 'Daily Backup1' does not have server access.
I'm not much of an SQL admin so I wasn't quite sure how to proceed. I
deleted the existing maintenance plans and created identical new ones
which worked fine for a couple of weeks. Now this error is back. What
exactly is causing this? Is there another way to fix it without deleting
and recreating these backup jobs?
Thanks
HamishTry setting the owner of the job to "sa", you can do that for the jobs that
Maint Plan creates.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hamish McBrearty" <h.mcbrearty@.rangiruru.school.nz> wrote in message
news:%237GPzUzuGHA.4460@.TK2MSFTNGP04.phx.gbl...
> Hi there
> My SQL server backups are running as nicely as they used to. Recently I
> got the following error:
> Message: The job failed. The owner () of job DB Backup Job for DB
> Maintenance Plan 'Daily Backup1' does not have server access.
> I'm not much of an SQL admin so I wasn't quite sure how to proceed. I
> deleted the existing maintenance plans and created identical new ones
> which worked fine for a couple of weeks. Now this error is back. What
> exactly is causing this? Is there another way to fix it without deleting
> and recreating these backup jobs?
> Thanks
> Hamish|||Tibor Karaszi wrote:
> Try setting the owner of the job to "sa", you can do that for the jobs
> that Maint Plan creates.
>
Really dumb question then, how do I do that?|||Edit the job. You find the jobs folder under SQL Server Agent.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hamish McBrearty" <h.mcbrearty@.rangiruru.school.nz> wrote in message
news:%234cem93uGHA.4612@.TK2MSFTNGP02.phx.gbl...
> Tibor Karaszi wrote:
> Really dumb question then, how do I do that?

Backup issues

Hi there
My SQL server backups are running as nicely as they used to. Recently I
got the following error:
Message: The job failed. The owner () of job DB Backup Job for DB
Maintenance Plan 'Daily Backup1' does not have server access.
I'm not much of an SQL admin so I wasn't quite sure how to proceed. I
deleted the existing maintenance plans and created identical new ones
which worked fine for a couple of weeks. Now this error is back. What
exactly is causing this? Is there another way to fix it without deleting
and recreating these backup jobs?
Thanks
HamishTry setting the owner of the job to "sa", you can do that for the jobs that Maint Plan creates.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hamish McBrearty" <h.mcbrearty@.rangiruru.school.nz> wrote in message
news:%237GPzUzuGHA.4460@.TK2MSFTNGP04.phx.gbl...
> Hi there
> My SQL server backups are running as nicely as they used to. Recently I
> got the following error:
> Message: The job failed. The owner () of job DB Backup Job for DB
> Maintenance Plan 'Daily Backup1' does not have server access.
> I'm not much of an SQL admin so I wasn't quite sure how to proceed. I
> deleted the existing maintenance plans and created identical new ones
> which worked fine for a couple of weeks. Now this error is back. What
> exactly is causing this? Is there another way to fix it without deleting
> and recreating these backup jobs?
> Thanks
> Hamish|||Tibor Karaszi wrote:
> Try setting the owner of the job to "sa", you can do that for the jobs
> that Maint Plan creates.
>
Really dumb question then, how do I do that?|||Edit the job. You find the jobs folder under SQL Server Agent.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Hamish McBrearty" <h.mcbrearty@.rangiruru.school.nz> wrote in message
news:%234cem93uGHA.4612@.TK2MSFTNGP02.phx.gbl...
> Tibor Karaszi wrote:
>> Try setting the owner of the job to "sa", you can do that for the jobs
>> that Maint Plan creates.
> Really dumb question then, how do I do that?

Backup into another machine.

I am trying to take the backup into another machine which is on the network
but failed to do so...
Like backup database Health to disk =
'\\nSys0120\Backup\Health\bkHealth05172005'
is the above command is okie ?
Thanks
Hi,
Command looks good, but there are Few Pre requisites to do backup remotely;
1. You Should start SQL server using Domain user who got access to remote
machine Share
2. Should have share in the remote machine
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharenameX\dbname.bak' with
init
Note:
Backup to remote machine will not work if you start SQL server using Local
system account
Thanks
Hari
SQL Server MVP
"Joh" <joh@.mailcity.com> wrote in message
news:%23bZ55ewWFHA.2520@.TK2MSFTNGP09.phx.gbl...
>I am trying to take the backup into another machine which is on the network
> but failed to do so...
> Like backup database Health to disk =
> '\\nSys0120\Backup\Health\bkHealth05172005'
> is the above command is okie ?
> Thanks
>
|||Thanks Hari.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:u6p7KtwWFHA.2700@.TK2MSFTNGP12.phx.gbl...
> Hi,
>
> Command looks good, but there are Few Pre requisites to do backup
remotely;
>
> 1. You Should start SQL server using Domain user who got access to remote
> machine Share
> 2. Should have share in the remote machine
> 3. If you need to schedule this as a job then SQL Agent should use the
same
> Domain user in which SQL server was started
> 4. Restart the services
> Now you can execute the Backup script with UNC path
> BACKUP Database <dbname> to disk='\\computername\sharenameX\dbname.bak'
with[vbcol=seagreen]
> init
>
> Note:
> Backup to remote machine will not work if you start SQL server using Local
> system account
>
> Thanks
> Hari
> SQL Server MVP
>
> "Joh" <joh@.mailcity.com> wrote in message
> news:%23bZ55ewWFHA.2520@.TK2MSFTNGP09.phx.gbl...
network
>
|||Hari, I did the same which you said but it gave me the following error
I used the following command
backup database test to disk = 'e:\bktest05172005'
"e:" is basically a map drive.
Error :
Windows - Delayed Write Failed
Windows was unable to save all the data for the file
\Device\LanmanRedirector\nSys0120\share\bktest0517 2005. The data has been
lost. This error may be caused by a failure of your computer hardware or
network connection. Please try to save this file elsewhere.
OK
Any idea ?
Thanks
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:u6p7KtwWFHA.2700@.TK2MSFTNGP12.phx.gbl...
> Hi,
>
> Command looks good, but there are Few Pre requisites to do backup
remotely;
>
> 1. You Should start SQL server using Domain user who got access to remote
> machine Share
> 2. Should have share in the remote machine
> 3. If you need to schedule this as a job then SQL Agent should use the
same
> Domain user in which SQL server was started
> 4. Restart the services
> Now you can execute the Backup script with UNC path
> BACKUP Database <dbname> to disk='\\computername\sharenameX\dbname.bak'
with[vbcol=seagreen]
> init
>
> Note:
> Backup to remote machine will not work if you start SQL server using Local
> system account
>
> Thanks
> Hari
> SQL Server MVP
>
> "Joh" <joh@.mailcity.com> wrote in message
> news:%23bZ55ewWFHA.2520@.TK2MSFTNGP09.phx.gbl...
network
>
|||Hi,
Please follow the same procedure. Do not use mapped drive. Just use UNC
path.
Thanks
Hari
SQL Server MVP
"Joh" <joh@.mailcity.com> wrote in message
news:u1a5gxwWFHA.3540@.TK2MSFTNGP09.phx.gbl...
> Hari, I did the same which you said but it gave me the following error
> I used the following command
> backup database test to disk = 'e:\bktest05172005'
> "e:" is basically a map drive.
> Error :
> --
> Windows - Delayed Write Failed
> --
> Windows was unable to save all the data for the file
> \Device\LanmanRedirector\nSys0120\share\bktest0517 2005. The data has been
> lost. This error may be caused by a failure of your computer hardware or
> network connection. Please try to save this file elsewhere.
> --
> OK
> --
> Any idea ?
> Thanks
>
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:u6p7KtwWFHA.2700@.TK2MSFTNGP12.phx.gbl...
> remotely;
> same
> with
> network
>
|||Hi Hari,
From remote machine when I am opening to take backup using browse option, path should be displayed of server in .net code. (like using enterprise manager remotely connected with other server. When you click on bacup database path from server will be displayed). In same way want to do in .net. Is it possible?
Thanks

Backup hangs in wait-state MSSEARCH

I'm experiencing a very annoying failure when trying to do a backup - I hope you can help where others (including me) have failed.

The setup is a SharePoint Portal Server 2003 version 11.0.8126.0 running on Windows server 2003 Standard edition Service pack 1; it has a SQL-server 2005 version 9.0.2047 running on Windows server 2003 Standard edition Service pack as a back-end.

When I issue a backup of the SharePoint database XXX_SITE which holds round 4 gb. of data (mainly documents) the backup process hangs with a Wait Type 'MSSEARCH', it makes no difference whether I issue it as a single job, or through a maintenance plan.

I tried to stop the MsSearch service on the SharePoint-server, and disabled the Full-Text search on the database but it makes no difference.

The only way I can get a backup is to reboot the server on which SQL-server resides (restarting the SQL-server makes it rather unstable), and do a manual back-up shortly after.

Kim,

This is very likely a bug. I suggest you contact Microsoft support.

Regards,

Matt Hollingsworth

Sr. Program Manager

Microsoft SQL Server

|||

That wait state indicates problems communicating between SQL and the MSSEARCH service via the COM interface.

There were several known problems that would lead to this situation which have been fixed in SP1, so that might be of help.

The quick solution is to cycle the MSSEARCH service, which should get backups moving.

If you're on SP1, and have this problem frequently, we can work with you to see what's going on. Event Viewer events about COM errors would be the first place to look.

|||

Hi Kevin,

We are on SP1, and the oddest thing is that I've disabled MSSEARCH (stopped the process) on the SharePoint server.

The Occurrence is highly frequent i.e. if there has been any user activity on the database the Backup hangs.

|||

I'm assuming that you have fulltext catalogs in your database?

So, for SQL 2005, the service is msftesql. If it is disabled, the backup should ignore the fulltext catalogs.

If we can get a dump for sqlservr.exe and msftesql.exe process together with all errorlog and SQLFT*.LOG file, I can take a look and see what is the problem. Feel free to contact me offline @. kevin.farlee@.microsoft.com

|||

Hi! Yes we did have full text catalogues in the database, but since I had disabled full text search for the database, and disabled msftesql, I didn't suspect them. I got however an article from Microsoft support, showing me how I could test for catalogues not properly removed. So I discovered that there still existed an old catalogue, which I ,after and only after re-enabling full text search, were able to delete, since then my backup has worked :0}

Thanks for the all the good will shown in these forums.

Kim Brandt Jensen