RSAT Tool

RSAT Tool

Remote Server Administration Tools (RSAT) enables IT administrators to remotely manage roles and features in Windows Server (2012 R2, 2012, 2008, 2008 R2)from a computer that is running in Windows 10, 8.1,  8, 7, and Vista.

Note: You can’t install the tool in home and standard edition of windows

Download link:

Windows 10:

https://www.microsoft.com/en-ph/download/details.aspx?id=45520

Windows 8.1

https://www.microsoft.com/en-us/download/details.aspx?id=39296

Windows 8

https://www.microsoft.com/en-ph/download/details.aspx?id=28972

Windows 7

https://www.microsoft.com/en-us/download/details.aspx?id=7887

Windows Vista

(x86) – https://www.microsoft.com/en-us/download/details.aspx?id=21090

(x64) – https://www.microsoft.com/en-us/download/details.aspx?id=18787

Source:

https://support.microsoft.com/en-ph/kb/2693643

Advertisements

Make visible network backup in MS SQL

Problem:

How to make visible network backup in MS SQL

Solution:

Run this commands:

First one was to identify that network drive in SQL Server, you will use the xp_cmdshell command. Before that, you need to make sure that the xp_cmdshell command is enabled in your SQL instance, as it is disabled by default. Use the sp_configure command to enable it as shown below:

EXEC sp_configure ‘show advanced options’, 1;
GO
RECONFIGURE;
GO

EXEC sp_configure ‘xp_cmdshell’,1
GO
RECONFIGURE
GO

Then,

Now define that share drive for SQL with the xp_cmdshell command as follows:

EXEC XP_CMDSHELL ‘net use H: \\RemoteServerName\ShareName’

It should now be mapped. In order to verify the new drive, you can use the below command that will show you all files in that newly mapped drive:

EXEC XP_CMDSHELL ‘Dir H:’

To Delete the network  backup path in MS SQL

Optionally you can delete that path after you finish using the below command:

EXEC XP_CMDSHELL ‘net use H: /delete’ /pre>