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
 
Joined
Nov 6, 2024
Messages
29
Reaction score
0
Secure your SharePoint on-premises or Online data with the Shoviv SharePoint Backup tool! Effortlessly backup SharePoint Online sites, libraries, and lists. Ensure data protection against accidental deletion, ransomware, and other threats. Maintain business continuity and safeguard your valuable SharePoint information. Try Shoviv today!
 

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