In addition to traffic, network reliability varies in different organizations.

We back up most of our SQL databases on various servers to one server, then those centralised backups go to tape....

Michael Valentine Jones (10/12/2010)

---

GilaMonster (10/12/2010)

---

Michael Valentine Jones (10/12/2010)

---

You go through this whole series of explanations every day with new people, even debunking the inevitable “truncate the log and shrink the...

Are you using BIDS ? I found this thread with 1 possible solution, not sure if it's relevant.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/7f5c9ae1-ecd3-4ead-98fd-2d074720e31d

Can you create a basic maint plan to schedule & run...

SKYBVI (10/11/2010)

---

?When our transaction log grows large and we want a quick way to shrink it, then we have to change the database recovery mode of the database we want...

Could you explain ? Your first post says Server1 to Server2. But bi-directional means both directions such as Server2 restored back to server1 ?

The more...

Maybe use SQLCompare and compare it to an empty database ?

Is this a one-time restore ? Or do you want the 2 databases regularly synchronized at some level ?

ROLLBACK is an 'undo', but you had to have used the BEGIN TRAN before you ran the DELETE statement.

For future reference, backup the data and make use of transactions when...

Basic steps for a "normal" restore:

1) Restore your most recent FULL

2) Restore your most recent DIFF (assuming it's more recent than the full)

3) Restore all the T-Logs more recent than...

george sibbald (10/11/2010)

---

If log is only 1% used suggests it is being backed up. check the properties of the database, does it have a value for last log backup?

Also does...

I'm not familiar with DPM. You need to backup the SQL database with the command BACKUP DATABASE

This can be done manually, through a script in a scheduled job, a...

General Guidelines - (specifc "best" options vary widely based on business needs) :

Create a maintenance Plan to run Transaction Log backups every 15 minutes or so.

Create a cleanup step that...

Gedas (10/8/2010)

---

You can kill rollback only by doing that but you must have latest backup:

1. stop SQL engine

2. delete db and tlog files

3. start SQL engine

4. delete db

5. restore...

Looks to me it has what you need (But I've been wrong before :-P)

frequency is: freq_subday_interval, int

"Number of freq_subday_type periods to occur between each execution of the...

msdb..sysschedules ?