All Questions
Tagged with log-shipping t-sql
6 questions
0
votes
1
answer
1k
views
The database is already fully recovered. RESTORE DATABASE is terminating abnormally
I've recently inherited the responsibilities of a DBA without the benefit of having any DBA training. We have a database (omitted name for security reasons) that is essentially setup to run in ...
1
vote
1
answer
621
views
MERGE vs DROP Table and Rebuild Indexes in SQL Server
I have a "log shipped" copy of a database that lives at a third party. Log shipping runs every 15 minutes at which time all connections to the database are dropped. The database is used for ...
- 620
0
votes
1
answer
852
views
Log shipping setup
Log shipping fails with the below error. Sql agent on secondary server has access to the folder and files in security. It is not a firewall issue. I created the jobs using the LS scripts as it fails ...
- 75
0
votes
3
answers
2k
views
How can I put a trigger on a system table to gather historical data?
I'm able to implement trigger on user define table but not on system table (log_shipping_primaries and log_shipping_secondaries), it store info about when the backup .bak file was generated and when ...
2
votes
1
answer
511
views
Log Shipping - Ignore deletions on a specific table
I've got a scenario where I have a database with one table that gets tons of inserts, and it's vital that the performance is excellent for those inserts.
I also have a lot of reports, some of which ...
- 44.6k
10
votes
1
answer
26k
views
T-SQL copy Logins, Users, roles, permissions etc
We have implemented log shipping as a database disaster recovery solution and want to know if there is a way I can use T-SQL to script all the logins, users, roles permissions etc to the master ...
user394721