![](https://www.hivelocity.net/wp-content/uploads/2021/01/knowledge-base-database.png)
Reset the SQL Server ‘sa’ user password?
Open Enterprise Manager and expand the registered SQL server. Expand Security. Click on Logins. Right-click the user “sa” and select Properties. Type the new password …
Open Enterprise Manager and expand the registered SQL server. Expand Security. Click on Logins. Right-click the user “sa” and select Properties. Type the new password …
SQL Server has no built-in support for restricting clients by IP address. The most common work-arounds are firewalls, IPSec, or third-party network layer filters to …
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 …
1. Open query analyser. Do not open Enterprise Manager. 2. Let the database be selected as “Master” 3. Fire the command BACKUP LOG “DATABASE_NAME” WITH …
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: …
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 …
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 …
Open Enterprise Manager and expand the registered SQL Server Expand Databases Right-click on the database that you want to backup, select All Tasks -> Backup …
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 …
Following commands also useful to take backup and restore of simple (not contains large objects) postgresql database. pg_dump mydb > db.out To restore database psql …
While gettting transferred from one host to another you need to take many precautions one of them is of your database (MySQL) You should backup …