Live Chat Software by NetForChoice
RSS Feed
Knowledgebase : Data Base
Backup rights If you are a member of the SQL Server SYSADMIN fixed server role, you can back up any databases on your SQL Server instance. You can also back up the databases for which you are the owner of. If you do not have backup rights to a specifi...
When you create a maintenance backup plan in SQL Server 2008 R2, you must identify how you want the plan to be set up. In this example, the maintenance plan is set up with full backups, differentials, and transactions logs. CHECK SQL SERVER AGENT SER...
The SELECT command is the most commonly used command in SQL. It allows database users to retrieve the specific information they desire from an operational database.
TO ADJUST THE MEMORY, PLEASE FOLLOW THESE STEPS: * Log into Microsoft SQL Server Management Studio either directly on your VPS or from your local machine. * Right click the SQL server name and select PROPERTIES. * Select the MEMORY tab. * Adj...
TO BACKUP YOUR MS SQL SERVER DATABASE, PLEASE FOLLOW THESE STEPS: 1. Log into your server through Remote Desktop Connection * Click START, PROGRAMS, MICROSOFT SQL SERVER 2005 and select SQL SERVER MANAGEMENT STUDIO EXPRESS or SQL SERVER MANAGEMENT...
* Open a web browser and connect to your Plesk Control Panel located at https://ip address:8443. * Login as the Administrator using the information sent to you in your setup email. * Click DOMAINS from the GENERAL menu. * Click the DOMAIN NAME ...
TO CONNECT TO YOUR DATABASE, PLEASE FOLLOW THESE STEPS: * On your local machine, click START, PROGRAMS, MICROSOFT SQL SERVER 2005 and select SQL SERVER MANAGEMENT STUDIO. * Enter the requested information: * SERVER TYPE: select Database Engine...
The maximum number of databases on a node of SQL Server 2008 is 32,767. Have a look at the following for more details of capacity limits in SQL Server...
* Expand a server group, and then expand a server. * Right-click DATABASES, and select ALL TASKS/ATTACH DATABASE. * Enter the name of the MDF (MASTER data file) of the database to attach. If you are not sure where the file is located, click browse ...
SA login is the administrative login for the MSSQL.. To Change the MSSQL SA password you have to execute following commands from command prompt of your server: 1) Go to the command prompt of the server & type in command prompt OSQL -L This command wil...
Help Desk Support from NetForChoice