Skip to content

Instantly share code, notes, and snippets.

@jjaramillo

jjaramillo/query.sql

Created July 4, 2014 04:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jjaramillo/3346e05fa6cdb24ca086 to your computer and use it in GitHub Desktop.
Save jjaramillo/3346e05fa6cdb24ca086 to your computer and use it in GitHub Desktop.
Download ZIP
If you ever get "Restore-SPSite : The operation that you are attempting to perform cannot be completed successfully. No content databases in the web application were available to store your site collection. The existing content databases may have reached the maximum number of site collections, or be set to read-only, or be offline, or may alread…
Raw
query.sql
SELECT [DeletionTime]
,[Id]
,[SiteId]
,[InDeletion]
,[Restorable]
FROM [content_database_name].[dbo].[SiteDeletion]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment