All Questions
Tagged with backup sql-server
24 questions
0
votes
0
answers
8
views
SharePoint sites not working after database restore from Production to DR
What is the correct way to move sites from production to DR? I followed these steps but it didn't work.
Took backup using Backup-SPSite on production
Restored site on DR using Restore-SPSite and it ...
- 3,714
0
votes
2
answers
42
views
Can I keep SQL Server and just restore Sharepoint to earlier time?
I have two separate VMs for sharepoint and SQL server. Unfortunately Sharepoint crashed and I couldn't repair it and just could restore a full OS backup (by Symantec System Recovery) for about one ...
- 1
1
vote
2
answers
863
views
How i can know the SQL service account for our sharepoint 2013 on-premises farm
To be able to run the BackUp-SPFarm i need to create a network location/drive and grant the sql service account read/write permission. but for our sharepoint on-premises 2013 /2016, how i can know ...
1
vote
1
answer
260
views
SharePoint Database Backup Failure on SqL Server
We do have two DB and two Application servers for high availability purpose .
Regarding SQL Server:
We have full and transaction log Backup .
We created a high availability group and define the two ...
- 135
1
vote
3
answers
190
views
Use compression during Database backup
In some circumstances, we can use compression to decrease the size of backups and the time to complete each backup.
I use following command to restore site.
Mount-SPContentDatabase "MyDatabase" -...
- 2,120
1
vote
0
answers
153
views
Sharepoint backup permissions
When I run a Sharepoint farm backup, I get an error Object SharePoint_2013_Config failed in event OnBackup. For more information, see the spbackup.log or sprestore.log file located in the backup ...
- 381
1
vote
1
answer
145
views
Restoring content database on SQL Server throws error database size limit
We a standalone SharePoint 2013 server with SQL Server Express. I have received a content database backup file of ~50MB. When I try to restore this content database backup file in our SQL Server ...
- 1,912
0
votes
2
answers
122
views
backup of sharepoint server 2010 portal
We use sharepoint server 2010 and windows server 2008 R2.
Currently, I'm taking backup of sharepoint portal through sql server management studio by backing up the databases (listed for each web ...
- 33
2
votes
2
answers
1k
views
unable to backup our sharepoint content database "Backup Database is terminating abnormally"
I want to backup our live Content Database, now i went to "Central aministration>>Backup>>perform backup",, but i could it find our content database. so i try running the ...
1
vote
2
answers
544
views
Get error after content database restore to another server
I have some problem with restore sharepoint content database.
get back up content data base from server A.
then restore to SQL server server B.
create a new web application in server B.
add restored ...
- 195
3
votes
1
answer
7k
views
Unable to perform A full Farm Backup
I have SharePoint 2013 server, containing one web application and three site collections.
I want to perform my first full farm backup, so I wrote the following command inside SharePoint PowerShell:
...
1
vote
1
answer
1k
views
Stuck backup process - Backup or restore is already running
From a few days I'm not able to performe backup. Backup always stuck on the same level - eg backup files have 10GB in jobs I see running backup proces and that it, backup stuck. When I delete that job ...
- 523
1
vote
1
answer
159
views
Restore farm backup and rename databases?
I'm using the Backup-SPFarm PowerShell cmdlet to backup our SP 2010 Server farm and all of its associated databases. We want to test our restore process, and I'm wondering if it's possible to restore ...
- 267
0
votes
1
answer
206
views
Backup/Restore which content database?
I have seen a few posts about backing and restoring SharePoint content databases from both Central Admin and using PowerShell. My question is relatively simple I hope.....
There are a number of ...
- 194
1
vote
1
answer
35
views
Should I perform scheduled content DB SQL backups in addition to scheduled granular backups?
Currently we have a series of scheduled granular backups for the site collection level that use the PS "Backup-SPSite" command (e.g. https://myportal.com). I test these backups frequently, and have ...
- 371
5
votes
1
answer
427
views
Do SQL Full Backups of Content Databases interfere with SharePoint differential backups using backup-sofarm
I've recently switched our SharePoint 2010 backups from using stsadm to the PowerShell backup-spfarm technique but just have a bit of a worry about differential backups.
Essentially we're running ...
- 175
1
vote
1
answer
101
views
How to backup specific ListItems to database?
We are running a ticketsystem on Sharepoint 2010 which got alarmingly large over the last few months. The ListView Threshhold currently sits at 15k for this WebApplication.
I am currently looking for ...
- 501
2
votes
1
answer
2k
views
Problem with PowerShell script in Tasks Sheduler Windows Server 2008 R2 - SharePoint Shell Access?
I have a problem with PowerShell script in Tasks Sheduler in Windows Server 2008 R2. I try to run Sheduler Tasks which run batch file which run PowerShell script to Backup Farm and while I choose "Run ...
- 523
0
votes
1
answer
745
views
Attaching and restoring document library files from a .mdf config database file?
We have a Symantec backup system that runs through all of the instances on a SQL2008 box and backsup data,
I would like to restore a corrupted document library and am wondering as to how I would ...
- 1,266
1
vote
2
answers
65
views
Backing up all sharepoint web applications?
I have a sharepoint farm hooked to a named instance of SQL2008.
I have a web application (it is also extended to another web app) that I would like to back up.
Here is what I am trying to achieve:
I ...
- 1,266
0
votes
0
answers
291
views
Move Sharepoint 2010 and SQL from one server to 2 different servers
I am moving a server that has Sharepoint 2010 Standard and SQL 2008 R2 installed to 2 different servers.
Could someone explain in detail, what are the steps to achieve this?
What are the things that ...
- 123
33
votes
6
answers
15k
views
Backup via SharePoint or backup via SQL Server?
How should I backup my 2010 SharePoint server? As I see it there are 3 choices:
Full Farm backup
Site collection backup
SQL Server backup
We're only doing backups using points 1 (occasionally) and ...
- 497
1
vote
1
answer
165
views
Advantage of SharePoint aware mirroring compared to normal SQL mirroring?
We are going to implement mirroring for our databases in order to increase the data redundancy. Our understanding is that SQL clustering won't help for this. Can someone please explain for me why we ...
- 197
2
votes
1
answer
2k
views
Restore Content Database to a different farm (Prod -> Beta -> Dev Servers)
My end goal is to have some code that automatically takes the Content Database backup from Production and automatically nightly restores it on Beta. Can I just do backup and restore sql commands? Or ...
user2686