How to Restore a Database on SQL Server Using .mdf, .ldf and .ndf Files
To restore a database on SQL Server using .mdf, .ldf, or .ndf files, rather than performing a restore, you will actually need to attach the …
Latest articles for category: Database
How to Execute a SQL Script (.sql File) on Your MSSQL Server Database
Executing a SQL Script in 6 Easy Steps Need to know how to execute a SQL script in MSSQL? Just follow these 6 simple steps: …
After restoring a SQL Server database, it show a status of “Loading”
Getting the database out of LOADING state When restoring multiple backups, each backup needs to use the NORECOVERY option to keep the database in a …
Change the TCP port of SQL Server
The default SQL Server port of 1433 is blocked at our border routers for security purposes. Therefore, the port that SQL Server runs on will …
Patch MSDE with the SQL SP4 update
This article assumes you are running the following configuration in MSDE: – mixed mode authentication – network protocols enabled Download the MSDE SP4 installer: https://www.microsoft.com/downloads/info.aspx?na=46&p=6&SrcDisplayLang=en&SrcCategoryId=&SrcFamilyId=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&u=http%3a%2f%2fdownload.microsoft.com%2fdownload%2f1%2fb%2fd%2f1bdf5b78-584e-4de0-b36f-c44e06b0d2a3%2fSQL2000.MSDE-KB884525-SP4-x86-ENU.EXE&oRef=http%3a%2f%2fwww.google.com%2fsearch%3fhl%3den%26q%3dms%2bsql%2bsp4 …
Access your database remotely on a cPanel hosting
First of all, it is important to explain how the database/database user names are formed. The names consist two parts — your cPanel username and …
Fix the MYSQL ERROR: Client does not support authentication protocol
Solution This error is encountered by both scripts and applications, that are unable to use the new authentication protocol introduced by MySQL 4.1.x. The only …
How do I modify PostgreSQL databases and user privileges?
You can edit the content of your databases and user privileges using the phpPgAdmin utility that comes with your control panel. To run phpPgAdmin, do …
How do I create PostgreSQL Users?
Unlike with other databases, a PostgreSQL database cannot be created without a user. You must stick to the following sequence: 1. Create a PostgreSQL user. …
How do I create/delete MS SQL databases?
Databases are created under logins and there can be several databases under one login. To create a MS SQL database, do the following: Click MS …
How do I setup MS SQL On Secondary Server?
Follow the steps below to Install and Configure SQL Server on Secondary Server. 1. Install SQL Server on Secondary Machine. 2. Install the Client Setup …
Showing 34 - 44 of 47 articles