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 …
Latest articles for category: Database
Restrict clients using my SQL Server by their IP Address?
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 …
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 …
Shrink MsSql DB Logs
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 …
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 …
Create a backup file of a SQL Server database
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 …
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 …
Take postgresql database backup
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 …
Transferring MySQL database to new server::
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 …
Showing 56 - 66 of 90 articles