Sign Up

Sign Up to our social questions and Answers Engine to ask questions, answer people’s questions, and connect with other people.

Have an account?

Sign In

Login to our social questions & Answers Engine to ask questions answer people’s questions & connect with other people.

Don't have account,

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account?

You must login to ask a question.

Need An Account,

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Search
Ask A Question
Home/MS SQL

Deepak Baghel – Blogs Latest Articles

On: January 28, 2025 Posted in CMD Comments: 0 Views: 4k

Full backups of all databases in the local named instance of SQLEXPRESS by using Windows Authentication

Example 1: Full backups of all databases in the local named instance of SQLEXPRESS by using Windows Authentication sqlcmd -S .\SQLEXPRESS -E -Q “EXEC sp_BackupDatabases @backupLocation=’D:\SQLBackups\’, @backupType=’F'” Example 2: Differential backups of all databases in the local named instance of ...

On: September 26, 2024 Posted in MS SQL Comments: 0 Views: 10k

Clear The SQL Server transaction log

Managing SQL Server Transaction Logs: A Step-by-Step Guide Effective management of transaction logs is crucial for maintaining the performance and storage efficiency of your SQL Server databases. In this post, we’ll walk through a practical example using the AdventureWorks2008R2 database, ...