Today I got an error in restoring a database on a test server. The database has 30 files which includes 1 data file, 1 log file and remains are .ndf files. please check the below error which i got while i restore the database. I have checked the restore query that one is correct solution is here very...
Read more
A linked server configuration allows Microsoft® SQL Server™ to execute commands against OLE DB data sources on different servers. Linked servers offer these advantages: Remote server access. The ability to issue distributed queries, updates, commands, and transactions on heterogeneous data sources across th...
Read more
Msg 945, Level 14, State 2, Line 1 Database 'db' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server error log for details. Got the above error message and i thought to shrinking of log will give solution. After shrink of log file I got one more error w...
Read more
Found this error on SQL server error log I search settings on my server and finally found one thing that, the user didn't have access to the sql computer from the network. Click Start -> Run, type “secpol.msc”, to open the Security Policy tool >> Local Policies >&...
Read more
I have just seen this thread Here. answere for this question is.....Yes. For taking backup of database into local path or network path (UNC) the user need db_backupoperator privelege only. Let's have a look into this scenario. I have two servers named as VMSYS2 and VMSYS3. I have taken a backup of VM...
Read more
Backup compression is an interesting feature that was introduced in SQL 2008. To take compressed backups on SQL server first, we need to enable the compression feature on the server level. We can enable backup compression feature in both GUI and command mode too. Using GUI: Connect to server and right clic...
Read more
Here is the script to find which port number is opend to connect SQL server. We all know 1433 is the default port number. Here i'm providing script that will help us to find which port is opend in the server. --------- DECLARE @tcp_port nvarchar(5) EXEC xp_regread @rootkey = 'HKEY_LOCAL_MACHINE', @key = 'SO...
Read more
The Tempdb ! Yes temporary database in SQL server is most important database. This is the temporary work space for all users as well as system too. Some times we will get an error in sql server error log that your tempdb database got filled. In such case we need to shrink tempdb log file as well as data fil...
Read more
As a database admin some times we may need to restore the database using previous backup's.There are many restore scenario's are available like full backup restore, full+differential backup restore, and full+ differential backup+ transaction log backup restore, and so on. Here is one more type of restoratio...
Read more
