Tagged Questions

0
votes
2answers
80 views

which sql server edition is good for practice [closed]

Which SQL Server (free/trail) would be good to install, which requires minimum resource and have maximum features. I mean, I can practice mirroring,logshipping and replication. I found this link, but ...
0
votes
1answer
43 views

Can I deactivate log shipping jobs without raising errors?

I've set up log shipping from Server A to Server B. I then set it up from B to A when B was the primary. I've reverted back to A being primary and disabled the backup, copy and restore jobs ...
0
votes
2answers
169 views

Resume Logshipping after Primary database restored

We have Database (D1) as a primary database and Log shipping setup to the secondary database called (LS_D1). Now what we are doing is taking backup of D1 database and restore it on D2 database. We do ...
0
votes
1answer
152 views

Getting timeouts and backup errors after mirroring and log shipping is setup

OS is Windows Server 2003 32 bit. SQL Server is SQL Server 2008 SP3 32 bit Today I finished configuring database mirroring and log shipping for 3 databases on this SQL instance and started receiving ...
2
votes
0answers
134 views

SQL Server Database Hot Backups: Which Technique(s) to Use for Multi-Level Replication?

I'm reading the many other posts here about mirroring vs. replication, but I'd still appreciate it if someone with some experience would weigh in. My small development team needs to have local ...
2
votes
2answers
60 views

Log shipping and log file: Can the log on the master or slave every be truncated/shrunk?

SQL Server 2008, standard log shipping setup (well, using redgate, but it is a pretty normal flow). On the replica, the log file is pretty big. Wondering if on the backup/replica servers it is OK to ...
1
vote
3answers
182 views

Does Log-Shipping need Transaction Log Backup from Primary Server?

In this video tutorial it is explained that we should use the transaction log backup of the primary server database and restore it into the secondary server database for log shipping. I was doing a ...
1
vote
0answers
48 views

Log Shipping Monitor Stored Procedure returning Null

I have log shipping setup. When I EXEC sp_log_shipping _monitor it returns all null values even though log shipping appears to be working fine. last_restored_file NULL last_copied_file NULL