how to take backup of site collection?
Hi Bhavesh, The command for a site collection back up is stsadm -o backup -url "http://servername/sites/sitename" -filename "C:\sitebackup.dat" url - url of the site collection filename - path with filename where to store the filename (extension of filename is .dat) Check this link to know more about the permissions. http://technet.microsoft.com/en-us/library/cc262704%28office.12%29.aspxThanks, Chanakya
February 26th, 2011 3:44am

You can use the same account for the backup under which you install the sharepoint. http://technet.microsoft.com/en-us/library/cc263445%28office.12%29.aspx Setup user account Domain user account. Member of the Administrators group on each server on which Setup is run. SQL Server login on the computer running SQL Server. Member of the following SQL Server security roles: securityadmin fixed server role dbcreator fixed server role If you run Stsadm commands that affect a database, this account must be a member of the db_owner fixed database role for the database. Server farm account Domain user account. If the server farm is a child farm with Web applications that consume shared services from a parent farm, this account must be a member of the db_owner fixed database role on the configuration database of the parent farm. Additional permissions are automatically granted for this account on Web servers and application servers that are joined to a server farm. This account is automatically added as a SQL Server login on the computer running SQL Server and added to the following SQL Server security roles: dbcreator fixed server role securityadmin fixed server role db_owner fixed database role for all databases in the server farm Note if you configure the Microsoft Single Sign-On Service, the server farm account will not automatically be given db_owner access to the SSO database. hope this help. thanks -ws SharePoint administrator, MCTS,MCITP
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2011 7:43am

Hi Bhavesh, The command for a site collection back up is stsadm -o backup -url "http://servername/sites/sitename" -filename "C:\sitebackup.dat" url - url of the site collection filename - path with filename where to store the filename (extension of filename is .dat) Check this link to know more about the permissions. http://technet.microsoft.com/en-us/library/cc262704%28office.12%29.aspxThanks, Chanakya
February 26th, 2011 7:49am

Hi, I want to take full backup of site collection, it's sub sites and SSP configuration at farm level. Office 2007 is installed on server 1 and SQL server 2005 is installed on server 2. I want to take backup using the stsadm command. so what permission and user I need to give on SQL server and office server 2007. can you pls give me full detail and command? I have no test environment. Thanks.
Free Windows Admin Tool Kit Click here and download it now
February 26th, 2011 7:50am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics