Search

1 to 10 of 30
Sort by

Discussion Thread 1
Tip of the Day: SQL Server Tips

Focus Search - Tip of the Day: SQL Server Tips


Discussion Post
Tip of the Day: SQL Server Tips

When provisioning a VDB y ou can select a SQL Server instance that has a higher version than the source database, if the source database version is higher than SQL Server 2005




Discussion Post
Using delphix for DBCC CHECKDB on SQL Server?

Hi all Has anyone tried running DBCC CHECKDB using Delphix...is it viable? We were thinking of running physical only on our prod dbs and provisioning to delphix to perform a full DBCC check. Is there a way to automate the provisioning of DBs? So the DB is provisioned, with a post script to run...



Discussion Post
Tip of the Day: Implementing SQL Server Pre- and Post-Scripts

For SQL Server, both dSource and VDB scripts can be either text or binary executables. For SQL Server dSources, pre- and post-scripts are incorporated into the validated sync process. For SQL Server single instance environments, scripts must exist and be readable on the staging environment. Scripts can also be run as part of the SQL Server VDB provisioning process, in which case they must exist and be readable on the target environment



Discussion Post
Tip of the Day: SQL Server Set Up and a Windows User

Must have the server role sysadmin for each SQL Server instance that the Delphix Engine will communicate with. In SQL Server Management Studio , navigate to Security > Logins >delphix trgt > Server Roles to set this role for the user