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 ...
Blog Latest Articles
Create a Full Database Backup MS Sql Sever Script
AdminHow to create a scheduled backup in SQL Express You have to follow these four steps to back up your SQL Server databases by using Windows Task Scheduler: Step 1: Create a stored procedure to back up your databases Connect ...
WordPress database to replace references to an old local URL To Server URL
Admin(http://localhost:8080/Demo) with a new live URL (http://Demo.com). The first query updates the home and siteurl options in the wp_options table to reflect the new URL, ensuring the site directs users to the correct address. The second query modifies the guid ...
Clear The SQL Server transaction log
AdminManaging 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, ...
Sql server Connection String with C#
AdminSetting Up the Connection String A connection string contains information about how to connect to the database. In your case, the connection string is: <add name=”DbConnection” connectionString=”Data Source=.;Initial Catalog=BH_Report;Integrated Security=true;” providerName=”System.Data.SqlClient”/> Data Source: The server where the database is ...