user9516827
  • Member for 3 years, 7 months
  • Last seen more than a month ago
Transaction Replication:Intialize from Backup
2 votes

Let this be helpful to someone who will have to deal with huge database and have to implement replication without initialization. I had set up transactional replication without initialization using ...

View answer
RESTORE hourly transaction log to every 10 min interval
0 votes

Hi i have created the script to restore every 1 minute and then copy the data to another table in another database. create table #GARrestorefiles( backupsetid int ,backupstartdate datetime ,...

View answer
Restore deleted data from a Table which occurred daily
0 votes

Hi i have created the script to restore every 1 minute and then copy the data to another table in another database. create table #GARrestorefiles( backupsetid int ,backupstartdate datetime ,...

View answer
Delete queries blocks other concurrent transactions
0 votes

Delete is not blocking now after i did the below changes. Removed page level locking on the index from both parent and child table. There was only a clustered index on the child table.Added Non ...

View answer
Index Seeks cost of OR operator
0 votes

Finally i was able to improve the performance by 80% after a long analysis. Like i mentioned in the post when i comment the block of sql query the query runs faster and in parallel mode,that was ...

View answer
How can I create a test copy of my production database that is updated daily on SQL Server?
0 votes

I would suggest you to go for log shipping. Set up the log shipping for production database with target initialize from a full backup.Then schedule the backup job LS Backup from the primary to run at ...

View answer