0
votes
1answer
69 views

SP central admin Cannot connect to the configuration database after reinstalling sql server 2008 r2

I have just re-installed SQL Server 2008 R2 in my Windows Server, but after installing the SQL Server, I am unable to open my central admin. On opening the central admin its showing me the message - ...
0
votes
0answers
35 views

Can't start configuration database service

TL;DR: I can't start the SQL Server service that my content database is on. I installed SharePoint Foundation 2010 on a Win7 box a while back. About a year ago I disabled some services (in ...
1
vote
2answers
422 views

Content Database Is Not Listing In SQL Management Studio

I have created a new SP web application and the content database name which I have given is WSS_Content_Test. Application created successfully(I checked out and found IIS Website and App pool is ...
2
votes
2answers
460 views

Should I regularly backup and shrink my content databases through SQL?

I've been contending with hard disk space on my SharePoint 2010 (with SQL 2008) environment for a while and I've just recently found out a few things that I think might help. Should I be regularly ...
3
votes
1answer
169 views

Remote BLOB Storage and Sharepoint 2010

I have a SharePoint Server 2010 documents library. Library's size - 20 Gb. Size increases each year by 1-2 GB. It stores files ranging in size from 1 to 50 MB. Files rarely change. Should I use the ...
3
votes
4answers
2k views

Claim SQL server space after content deleted from SharePoint

We have a site collection with its own database where we have been testing migration of a department's shared drive content (about 40GB) via a third party tool. The test migrations went fine. Before ...
0
votes
0answers
18 views

Different usages shown in SQL server 2008 and SharePoint 2010

The content database size in SQL server is 84GB while shown up in Sharepoint 2010 - Site Collections Quotas and Locks is 698GB. There is a discrepancy of 15GB usage. Why the usages are different?
0
votes
3answers
1k views

Content Database showing 0 (zero) site collection after content database attach

I have two server farms, Server farm 1 and Server farm 2. Server farm 2 runs SharePoint 2010 Enterprise with SQL Server 2008 R2 Enterprise and Server 1 runs SharePoint 2010 Enterprise with SQL Server ...
1
vote
1answer
771 views

How to design for large content databases?

Although single content databases of upto 200GB is possible in Sharepoint 2010, administering and managing such a db would be a nightmare. What would you suggest for options in a case where there is ...