how to backup a database from clients via Windows PowerShell

-
You may need to backup a database remotely via Windows Power Shell.

First of all, you have to install SQL Server PowerShell applet to local machines.

to verify if Applet exists:

1 - Open Windows PowerShell (It is highly recommended to open it with Administrator)
2 - Enter sqlps, if you get an error about unrecognized command. You have to install SQL Client tools or any other feature from SQL Server Installation Disc. (Feature based installation covers necessary Power Shell Scripts)

Second, execute below commands over Windows PowerShell to backup a database;

PS C:\Users\[....]> sqlps
Microsoft (R) SQL Server (R) PowerShell
Version 12.0.2000.8
Copyright (c) 2014 Microsoft. All rights reserved.

PS SQLSERVER:\>; Backup-SqlDatabase -ServerInstance dbaseServer050 -Database CrmOrganization_MSCRM -BackupFile \\ShareMap\BackupTemp\CrmOrganization_MSCRM.bak

PS SQLSERVER:\>


Good Luck...

Comments

Post a Comment

Popular posts from this blog

Could not load file or assembly 'System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. The system cannot find the file specified at Configuration class initiation in CrmServiceHelper.cv

-
Hello, I faced an error when i iniated configuration class of CrmServiceHelper of Microsoft in order to setup Dynamics 365 Customer Engagement (Dynamics CRM online) SDK connection. The mesage was " Could not load file or assembly 'System.ServiceModel, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. The system cannot find the file specified. " Here is the fix: Open NuGet Package Manageer froom Tools view in Visual Studio and make an online search for System.ServiceModel.Primitives finally install it to the project. enjoy... Muhammet Atalay
Read more

Exception caught instantiating TERADATA report server extension SQL Reporting Services

-
Hi, If you face an error in Reporting Services Log File (C:\Program Files\Microsoft SQL Server\MSRSxx_xx.MSSQLSERVER\Reporting Services\LogFiles) such as : extensionfactory!ReportServer_0-1!ea4!03/26/2013-08:20:15:: e ERROR: Exception caught instantiating TERADATA report server extension:  System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.  ---> System.IO.FileNotFoundException: Could not load file or assembly 'Teradata.Client.Provider, Version=12.0.0.0, Culture=neutral, PublicKeyToken=76b417ee2e04956c' or one of its dependencies. The system cannot find the file specified. File name: 'Teradata.Client.Provider, Version=12.0.0.0, Culture=neutral, PublicKeyToken=76b417ee2e04956c'    at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)    a...
Read more

you face "ISV code aborted the operation" when you change status of the any record in Dynamics CRM 2013

-
Hi,    You may get an error as "ISV code aborted the operation" when you set "activate" or "deactivate" of any record. it seems that because we’re not actually performing the status/state change action directly on the record . The event itself does “bubble up”, though, so stopping the status change also rolls back the entire transaction and none of the fields on the records being the targets of the operation change in the dirty form  ( .getDirty() -> true).  That’s the important part, after all.
Read more