RESTORE DATABASE using command

-

RESTORE DATABASE using command

I found this error message when i restore the database using the GUI and it appear this error message "Error 3154: The backup set holds a backup of a database other than the existing database"
It because of trying to restore database on an existing active database.

Solution:
RESTORE DATABASE DatabaseName
FROM DISK = 'C:\myDatabase.bak'
WITH REPLACE

Use WITH REPLACE when using RESTORE command when u saw above error message "Error 3154: The backup set holds a backup of a database other than the existing database"

Comments

Post a Comment

Popular posts from this blog

sharepoint people picker is not working in central admin sharepoint

-
We have to check peoiple picker is activated or not for the CA and web application. First check AD features are are installed or not. or Then using stsadm this coomand execute. STSADM.exe -o getsiteuseraccountdirectorypath -url  http://intranet If you get output like this: DC=childdomain,DC=rootdomain,DC=local  Then you need to run the following command to change the people picker search scope to search the entire forest: STSADM.exe -o setsiteuseraccountdirectorypath -path "" -url  http://intranet or  stsadm –o setproperty –pn "peoplepicker-searchadforests" –pv "Domain" -url http://sharepointlive:8080/ OR Using this powershell script $webapp = get -spwebapplication http : / / myurl . com $webapp . peoplepickersettings #this showed that there was something set in a sub property of peoplepickersettings called ActiveDirectoryCustomFilter.   #next step to fix this was to reset that property, the code below was used: $webapp ...
Read more

what is Event Cache table in sharepoint

-
Every Content database in SharePoint Contains an EventCache table that is the change log for objects contained in the database. Each row in this table is depicting a change in an object where columns usually contain information such as the date and time of a change, the type of object that was changed, the nature of the change, and a unique identifier for the object. EventCache table is important because it stores the list of site events for which users might have requested alerts.
Read more

The term 'Connect-MsolService' is not recognized as the name of a cmdlet, function, script file, or operable program

-
Following worked for me: Uninstall the previously installed ‘Microsoft Online Service Sign-in Assistant’ and ‘Windows Azure Active Directory Module for Windows PowerShell’. Install 64-bit versions of ‘Microsoft Online Service Sign-in Assistant’ and ‘Windows Azure Active Directory Module for Windows PowerShell’. https://littletalk.wordpress.com/2013/09/23/install-and-configure-the-office-365-powershell-cmdlets/ If you get the following error  In order to install Windows Azure Active Directory Module for Windows PowerShell, you must have Microsoft Online Services Sign-In Assistant version 7.0 or greater installed on this computer , then install the Microsoft Online Services Sign-In Assistant for IT Professionals BETA:  http://www.microsoft.com/en-us/download/details.aspx?id=39267 Copy the folders called MSOnline and MSOnline Extended from the source C:\Windows\System32\WindowsPowerShell\v1.0\Modules\ to the folder C:\Windows\SysWOW64\WindowsPowerShell\v1.0...
Read more