If you want to fetch data from Oracle to SQL Server, you can use Linked Servers features in SQL Server Database. Linked Server is like a database link (Dblink). Installation steps Install Oracle Client on SQL Server database server Restart SQL Server database service Configure OraOLEDB.Oracle provider in SQL Server database Create user for remote…
Category: Administration
MsSQL Server Recovery Models Features
SQL Server backup and restore operations occur within the context of the recovery model of the database. Recovery models are designed to control transaction log maintenance. A recovery model is a database property that controls how transactions are logged, whether the transaction log requires (and allows) backing up, and what kinds of restore operations are…
Create Schedule Job For Execute Procedure in SQL Server 2008
If you want to run procedure or any query as scheduling, you can use job in SQL Server Database. For this process, you can use below operations. Right Click On SQL Server Agent > New > Job
MsSQL Server 2008 R2 Failover Cluster Installation on Windows Server 2008 R2 Enterprise x64 on VMware
Failover Cluster System Benefits Protection at the instance level through redundancy Automatic failover in the event of a failure (hardware failures, operating system failures, application or service failures) Support for a broad array of storage solutions, including WSFC cluster disks (iSCSI, Fiber Channel, and so on) and server message block (SMB) file shares. Disaster recovery…
RAID (Redundant Array of Independent Disks)
RAID (redundant array of independent disks; originally redundant array of inexpensive disks) is a way of storing the same data in different places (thus, redundantly) on multiple hard disks. By placing data on multiple disks, I/O operations can overlap in a balanced way, improving performance. Since multiple disks increases the mean time between failures, storing…
Schedule Backup in SQL Server 2008 Express Edition
If you use SQL Server Express, You can take schedule backup with sql script and windows task schedule. Firstly, you have to create backup script, after you have to create batch file for task schedule. Create Backup Script BACKUP DATABASE [dbname] TO DISK = N’D:\SQLBackup\dbname.bak’ WITH NOFORMAT, NOINIT, NAME = N’dbname-Full Database Backup’, SKIP, NOREWIND,…