Problem with getting a full backup from sharepoint farm

B

Bahram

We have a server farm (one virtual machine for SQL2008,one for SharePoint and
one for project server), and the system works fine. I am able to get a backup
using stsadm -o backup -url <url> -filename <name>, but when I try to get a
full backup using SharePoint backup and restore tools or stsadm -o backup
-directory E:\Backup -backupmethod full I am getting error message regarding

WSS_Search_sharepoint-serber-name

I am getting the same error message when I run the full back from project
server server.
Any thought on this issue? Any port/services that I need to open?
Thanks
 
B

Bahram

i haven't got any respond yet.
Here is my error:
Error: Object SharePoint_Config failed in event OnBackup. For more
information, see the error log located in the backup directory.
SqlException: Cannot open backup device 'E:\Backup\spbr0003\00000016.bak'.
Operating system error 3(The system cannot find the path specified.).
BACKUP DATABASE is terminating abnormally.
[6/2/2010 1:53:40 PM]: Debug: at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)

We use a genereic accound, and we are not running based on the administrator
, and the sql,projectserver and sharepoint has been installed based on the
generic accound. I've added the generic accound to the e:/backup folder.
Please advice.

Thanks
 
B

Bahram

I found my problem. Just in case if anyone faces the same issue:
The account the SQL server is running under needs write access
to the file share where the backup files will go in order to write the .bak
files. Once I gave the SQL account rights there, the backup worked
perfectly.
Shared the folder if it is not a shared/web folder and give the sql server
an access and point your backup to \\projectserver\backupfolder
Thanks

Bahram said:
i haven't got any respond yet.
Here is my error:
Error: Object SharePoint_Config failed in event OnBackup. For more
information, see the error log located in the backup directory.
SqlException: Cannot open backup device 'E:\Backup\spbr0003\00000016.bak'.
Operating system error 3(The system cannot find the path specified.).
BACKUP DATABASE is terminating abnormally.
[6/2/2010 1:53:40 PM]: Debug: at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)

We use a genereic accound, and we are not running based on the administrator
, and the sql,projectserver and sharepoint has been installed based on the
generic accound. I've added the generic accound to the e:/backup folder.
Please advice.

Thanks

Bahram said:
We have a server farm (one virtual machine for SQL2008,one for SharePoint and
one for project server), and the system works fine. I am able to get a backup
using stsadm -o backup -url <url> -filename <name>, but when I try to get a
full backup using SharePoint backup and restore tools or stsadm -o backup
-directory E:\Backup -backupmethod full I am getting error message regarding

WSS_Search_sharepoint-serber-name

I am getting the same error message when I run the full back from project
server server.
Any thought on this issue? Any port/services that I need to open?
Thanks
 
B

Bahram

Now my question is, is there any way to overwrite the data on stsadm -o
backup -directory <path> -backupmethod full -quiet command?
I think -overwrite only works on when we use stsadmn with -url -filename,etc.
I want to get a full backup on my project severe and I want to schedule it
with windows scheduler, so I need a command to overwrite my data, and I don't
want the system to create a new folder each time.

Please let me know.

Thanks

Bahram said:
I found my problem. Just in case if anyone faces the same issue:
The account the SQL server is running under needs write access
to the file share where the backup files will go in order to write the .bak
files. Once I gave the SQL account rights there, the backup worked
perfectly.
Shared the folder if it is not a shared/web folder and give the sql server
an access and point your backup to \\projectserver\backupfolder
Thanks

Bahram said:
i haven't got any respond yet.
Here is my error:
Error: Object SharePoint_Config failed in event OnBackup. For more
information, see the error log located in the backup directory.
SqlException: Cannot open backup device 'E:\Backup\spbr0003\00000016.bak'.
Operating system error 3(The system cannot find the path specified.).
BACKUP DATABASE is terminating abnormally.
[6/2/2010 1:53:40 PM]: Debug: at
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean
breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection)

We use a genereic accound, and we are not running based on the administrator
, and the sql,projectserver and sharepoint has been installed based on the
generic accound. I've added the generic accound to the e:/backup folder.
Please advice.

Thanks

Bahram said:
We have a server farm (one virtual machine for SQL2008,one for SharePoint and
one for project server), and the system works fine. I am able to get a backup
using stsadm -o backup -url <url> -filename <name>, but when I try to get a
full backup using SharePoint backup and restore tools or stsadm -o backup
-directory E:\Backup -backupmethod full I am getting error message regarding

WSS_Search_sharepoint-serber-name

I am getting the same error message when I run the full back from project
server server.
Any thought on this issue? Any port/services that I need to open?
Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top