In the article named “FileGroup Backup and FileGroup Restore Operations On SQL Server(Partial Backup-Restore)“, I explained the issue that we can restore only read-write …
Read More »
In the article named “FileGroup Backup and FileGroup Restore Operations On SQL Server(Partial Backup-Restore)“, I explained the issue that we can restore only read-write …
Read More »Detect Orphaned Windows Logins(sp_validatelogins) With this system SP, you can identify Windows Logins that have been deleted from Active Directory on a SQL Server Instance. …
Read More »With the DB link, you can get an ORA-01591 error if you join the tables in the queried database with the tables in a …
Read More »For more information about Filegroup, please read the article “How to Create a Database on SQL Server“. Especially in large and partitioned databases, we …
Read More »When you try to get a backup with Rman, if you get errors like ORA-27086, ORA-01580, the first place you should check is nfs …
Read More »We perform FileGroup Backup and Restore operations in databases that are usually large and have more than one filegroup, while some of the filegroups are …
Read More »In some cases, automatic maintenance jobs are closed in databases. In this case, the schema statistics are not collected and cause serious performance problems. …
Read More »Tail Log Backup takes the backup of log records that have not yet been backed up. We can use this backup to return to …
Read More »If you receive errors in the form of ORA-20005 and ORA-06512 during the collection of the table statistics, you must unlock the relevant table …
Read More »DBCC CHECKTABLE is used to test the consistency of a table or indexed view. The DBCC CHECKTABLE command performs the same operations as the DBCC …
Read More »