probably log shipping, but it depends For mirroring you will need to create snapshots and have enterprise edition.

Neither are perfect though, with log shipping you will need to decide what...

Lynn, I would presume (and hope) the standard backup history related tables in msdb are still updated.

bulk logged is the best mode to control growth during index rebuilds, then a full backup afterwards. Note log backups will still be large though. You could also try backing...

the name of the SQL service in the cluster, i.e. the name you use to connect to the database engine.

The packages are normally imported to msdb, thats better for security...

use the virtual sql server name

note: 6 year old thread

is a spike of 30% actually causing you a problem?

If you really want to know the SQL causing the issue run a server side profiler trace (google that) and a...

you would use the norecovery option on a log backup when you want to swap primary and secondary roles in a logshipping set up without needing to reinitialise from...

highlight the jobs in object explorer (F7) you can script them all out in one go.

any reason you cannot script the jobs out via the gui?

unless they are maintenance plan jobs in which case you are best off recreating the maintenance plans

nice question

ideally the same version in DR as you have in Live.

Hugo Kornelis (6/26/2013)

---

PRR.DB (6/25/2013)

---

I have taken "TestPartition" Database backup (In that db , 5 table are partitioned with 10 file-groups(.ndf files)) then I executed below command

RESTORE FILELISTONLY FROM disk='D:\DB\Backup\TestPartition.bak'

It is...

the error could be transient or sporadic. definitely get the disks checked and make sure all drivers up to date.

Very odd dropping and recreating users should apparently resolve this, makes...

either that .bak file you bought over had a corruption in it or you have an underlying system problem (disk or driver)

Have you run the dbcc checkdb? thats the first...