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

Complex Query in QueryExpression in Microsoft CRM 2011

-
Hi, Here is tables and relation,QueryExpression statement afterwards. contact 1--->N new_ticket N --> N new_tour QueryExpression query = new QueryExpression()                     {                         EntityName = "contact",                         ColumnSet = new ColumnSet(new string[] {                                                             "contactid",                                                             "firstname",                                                             "lastname",                                                             "birthdate",                                                             "fullname"                                                             }                                                   )                     }; Query Expression will execute the query against contact. For performance issue; do not retrieve any columns that we do
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)    at System.Refl
Read more

Microsoft Power Apps Portal integration with Dynamics 365 CE On-Premise - Step By Step Guide

-
Image
 Hello, It has been quite long since I did not post any guides with you. Today, I am going to share a PoC of mine result with detailed screenshots as much as possible.  You will see how we can easily position Power Apps Portal in front of Dynamics 365 CRM ( CE ) Engine 9.x on-premise edition. You are going to see following subjects in the study; Solution generation for the scenario in Dynamics 365 CRM on-premise  Create Solution Create Custom Entity Add Existing entity to a custom solution 1:N relation Form creation for Portal visibilities for portal specific fields Microsoft Common Data Service (Microsoft Dataverse) - an environment -creation Solution generation for the scenario in Dynamics 365 CRM on-premise  Microsoft Power Apps Portal creation (Starter Portal) in the environment Microsoft Dynamics 365 On-Premise customization for PoC Scenario implementation Reflecting Dynamics 365 On-Premise solution to CDS (Microsoft Dataverse) - to the environment- Aligning Microsoft Power Apps P
Read more