Cannot connect to SQL Server from a remote machine? How to troubleshoot , when we are unable to connect the SQL Server from other machine?...follow below steps... and identify the issue... 1. Make sure SQL Server is running on the target machine ( verify...
Commonly used scripts to troubleshooting... Regular usage scripts for SQL Server dba ===================== 1. On which drive the database files(mdf & ldf) are located? use master select * from sysaltfiles where filename like 'd%' (OR) select * from master..sysaltfiles...
How do you recover a database which was crashed or corrupted using database backups? This is most important questions and is asked almost in every interview. Failing to answer this question may reduce your chances of getting the job. Normally, you will...
How will database recovery model impact database backups? Recovery model basically tells SQL Server on what data to store inside transaction log file and how long to keep that data. There are three types of recovery models in SQL Server which are SIMPLE,...
Can we perform a SQL Server compressed backup? Starting SQL Server 2008, we can perform a compressed backups. All types of backups can be performed with compressed option. Prior to SQL Server 2008, backups may need to be compressed using third party tools...
How can you automate performing database backups in SQL Server? We can created maintenance plans and use backup tasks option and schedule the maintenance plan to perform backups automatically. We can also create SQL Server jobs and specify the backups...
How do you recover a database which was crashed or corrupted using database backups? This is most important questions and is asked almost in every interview. Failing to answer this question may reduce your chances of getting the job. Normally, you will...
How to plan a backup strategy in SQL Server? There are various types of backup options available in SQL Server and as a DBA we need to plan what backups need to be performed and how frequently those backups need to be performed. The planning for database...
Common Backup errors and Troubleshooting step Common Backup errors and Troubleshooting steps:- You can find here some of the frequent or common errors faced which manually performing a database backup or an automated maintenance plan or custom backup...
Hiding the SQL Server over the network... Hiding the SQL Server over the network... As you can see all of my instances are visible on the network. If I want to hide this information from people on my network, it can be done easily. SQL Server allows us...
