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

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

CAML Query syntax and options in SharePoint

-
As Small syntax error or order of tag in spquery can result any web part (or any thing in which spquery is used) doesn’t work, I’m explaining SPQuery with example, hope which may help you. CAML (Collaborative Application Markup Language) SPQuery  is the SharePoint object which is used to perform a query operation against SharePoint data. SPList.getItems(SPQuery)  is the step, will return SPListItemCollection  which satisfies the query.SPQuery has one data member ‘ Query’ , which need to set before passing SPQuery object to  SPList . Some Properties Properties Description RowLimit Gets or sets a limit for the number of items returned in the query per page. <RowLimit>10</RowLimit> --- Can be used as: query.rowLimit = 10; ViewFields Gets or sets the fields that are displayed in the query. <ViewFields>         <FieldRef Name='Title'/>         <...
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