SQL database backup server step by step

In this article I am talking regarding different procedure of Database backup in Microsoft SQL server. I am discussing below listed point.

(1)Take Backup using Wizard.

(2)Take backup using generates script functionality.

Let’s start

(1)    Take Backup using Wizard

Right click on database which you want to take backup-> go to ->Task->go to->Back Up

Using below window you can configure general tab which contain backup type you can changes backup type (Full backup, Differential backup) according to requirement and you can change backup physical location in Disk.

Full backup-> full backup Take backup of whole database.

Differential backup->this type of backup capture only the data that has changes since full backup.

After that configure Option tab->Go to Option tab in same window.

In this window you can select option like append to existing backup set and overwrite all existing backup set and you can also set backup compression option for shrink database backup file.

Finally click ok button show in below.

After completion of task you see this window. This window display successful message this message indicate Database backup task is completed successfully.

(2)    Take backup using generates script functionality

(a)This type of backup functionality use when you are unable to restore backup file on other server database.

(b) If in your database large amount of data then this type of backup functionality is not suitable.

But in some cases generate script functionality is very useful.

Right click on database->go to->Task->go to->Generate Script

In this window you can configure multiple things:

(a)Select database object to script

(b) Configure how script should be save and publish.

(a)Select database object to script-> in this tab two options are available one is script entire database object or select some specific database object like table, views, stored procedure etc.

(b) Configure how script should be save and publish-> in this tab also two option available one save script to a specific location on your disk or save to clipboard or save to new query window.

Here you can also configure advance setting using advance button.

For advance setting go to this window. Here you can select option according requirement. Here I am selecting type of data to script option is schema and data that means I want to generate script of database schema and data. You can select option according to own need. After that click ok button.

After completed all tasks go to save or publish tab of this window. After that you can see script in new query window according to your setting. Then click on finish button.

  

You can see output here.

Useful ASE stored procedures to check various constraints

You can use the below set of stored procedures to find the same

Basic Level sp_helpindex tablename
Details
sp_fkeys tablename Gives details of foreign keys on the table having primary keys
sp_pkeys tablename Give details of the primary keys
sp_helpcontraint tablename, detail Gives details of all contraints on the table
sp_helpkey tablename Gives details of the keys associated with the table

How to use an error class for ignoring all errors

Create a new error class on replication server:
create error class ignore_all
go
On RSSD
rs_init_erroractions ignore_all, rs_sqlserver_error_class
go
This would initialise the new error class with all errors in default error class

On the Replication server, assign action ignore to all error types

assign action ignore for ignore_all to 0
assign action ignore for ignore_all to 102
assign action ignore for ignore_all to 215
assign action ignore for ignore_all to 250
assign action ignore for ignore_all to 273
assign action ignore for ignore_all to 275
assign action ignore for ignore_all to 282
assign action ignore for ignore_all to 289
assign action ignore for ignore_all to 310
assign action ignore for ignore_all to 314
assign action ignore for ignore_all to 417
assign action ignore for ignore_all to 502
assign action ignore for ignore_all to 526
assign action ignore for ignore_all to 540
assign action ignore for ignore_all to 636
assign action ignore for ignore_all to 646
assign action ignore for ignore_all to 660
assign action ignore for ignore_all to 701
assign action ignore for ignore_all to 807
assign action ignore for ignore_all to 841
assign action ignore for ignore_all to 846
assign action ignore for ignore_all to 847
assign action ignore for ignore_all to 905
assign action ignore for ignore_all to 910
assign action ignore for ignore_all to 918
assign action ignore for ignore_all to 921
assign action ignore for ignore_all to 922
assign action ignore for ignore_all to 924
assign action ignore for ignore_all to 927
assign action ignore for ignore_all to 928
assign action ignore for ignore_all to 935
assign action ignore for ignore_all to 936
assign action ignore for ignore_all to 937
assign action ignore for ignore_all to 938
assign action ignore for ignore_all to 948
assign action ignore for ignore_all to 950
assign action ignore for ignore_all to 951
assign action ignore for ignore_all to 1028
assign action ignore for ignore_all to 1101
assign action ignore for ignore_all to 1105
assign action ignore for ignore_all to 1126
assign action ignore for ignore_all to 1204
assign action ignore for ignore_all to 1205
assign action ignore for ignore_all to 1283
assign action ignore for ignore_all to 1510
assign action ignore for ignore_all to 1512
assign action ignore for ignore_all to 1516
assign action ignore for ignore_all to 1517
assign action ignore for ignore_all to 1518
assign action ignore for ignore_all to 1524
assign action ignore for ignore_all to 1566
assign action ignore for ignore_all to 1601
assign action ignore for ignore_all to 1624
assign action ignore for ignore_all to 1703
assign action ignore for ignore_all to 1708
assign action ignore for ignore_all to 1713
assign action ignore for ignore_all to 1728
assign action ignore for ignore_all to 1805
assign action ignore for ignore_all to 1812
assign action ignore for ignore_all to 1821
assign action ignore for ignore_all to 1911
assign action ignore for ignore_all to 1912
assign action ignore for ignore_all to 1918
assign action ignore for ignore_all to 2403
assign action ignore for ignore_all to 2411
assign action ignore for ignore_all to 2412
assign action ignore for ignore_all to 2414
assign action ignore for ignore_all to 2415
assign action ignore for ignore_all to 2416
assign action ignore for ignore_all to 2528
assign action ignore for ignore_all to 2536
assign action ignore for ignore_all to 2537
assign action ignore for ignore_all to 2538
assign action ignore for ignore_all to 2539
assign action ignore for ignore_all to 2551
assign action ignore for ignore_all to 2552
assign action ignore for ignore_all to 2553
assign action ignore for ignore_all to 2554
assign action ignore for ignore_all to 2555
assign action ignore for ignore_all to 2569
assign action ignore for ignore_all to 2570
assign action ignore for ignore_all to 2572
assign action ignore for ignore_all to 2579
assign action ignore for ignore_all to 2583
assign action ignore for ignore_all to 2592
assign action ignore for ignore_all to 2593
assign action ignore for ignore_all to 2601
assign action ignore for ignore_all to 2605
assign action ignore for ignore_all to 2606
assign action ignore for ignore_all to 2607
assign action ignore for ignore_all to 2608
assign action ignore for ignore_all to 2611
assign action ignore for ignore_all to 2612
assign action ignore for ignore_all to 2614
assign action ignore for ignore_all to 2701
assign action ignore for ignore_all to 2704
assign action ignore for ignore_all to 2707
assign action ignore for ignore_all to 2708
assign action ignore for ignore_all to 2709
assign action ignore for ignore_all to 2712
assign action ignore for ignore_all to 2713
assign action ignore for ignore_all to 2720
assign action ignore for ignore_all to 2722
assign action ignore for ignore_all to 2723
assign action ignore for ignore_all to 2725
assign action ignore for ignore_all to 2726
assign action ignore for ignore_all to 2785
assign action ignore for ignore_all to 2788
assign action ignore for ignore_all to 2789
assign action ignore for ignore_all to 2902
assign action ignore for ignore_all to 3014
assign action ignore for ignore_all to 3015
assign action ignore for ignore_all to 3116
assign action ignore for ignore_all to 3124
assign action ignore for ignore_all to 3125
assign action ignore for ignore_all to 3126
assign action ignore for ignore_all to 3127
assign action ignore for ignore_all to 3128
assign action ignore for ignore_all to 3134
assign action ignore for ignore_all to 3135
assign action ignore for ignore_all to 3136
assign action ignore for ignore_all to 3216
assign action ignore for ignore_all to 3227
assign action ignore for ignore_all to 3229
assign action ignore for ignore_all to 3236
assign action ignore for ignore_all to 3309
assign action ignore for ignore_all to 3405
assign action ignore for ignore_all to 3406
assign action ignore for ignore_all to 3407
assign action ignore for ignore_all to 3408
assign action ignore for ignore_all to 3409
assign action ignore for ignore_all to 3410
assign action ignore for ignore_all to 3411
assign action ignore for ignore_all to 3433
assign action ignore for ignore_all to 3442
assign action ignore for ignore_all to 3444
assign action ignore for ignore_all to 3448
assign action ignore for ignore_all to 3449
assign action ignore for ignore_all to 3462
assign action ignore for ignore_all to 3470
assign action ignore for ignore_all to 3506
assign action ignore for ignore_all to 3507
assign action ignore for ignore_all to 3604
assign action ignore for ignore_all to 3605
assign action ignore for ignore_all to 3612
assign action ignore for ignore_all to 3613
assign action ignore for ignore_all to 3614
assign action ignore for ignore_all to 3615
assign action ignore for ignore_all to 3617
assign action ignore for ignore_all to 3620
assign action ignore for ignore_all to 3621
assign action ignore for ignore_all to 3625
assign action ignore for ignore_all to 3629
assign action ignore for ignore_all to 3717
assign action ignore for ignore_all to 3721
assign action ignore for ignore_all to 3733
assign action ignore for ignore_all to 3734
assign action ignore for ignore_all to 3735
assign action ignore for ignore_all to 3736
assign action ignore for ignore_all to 4016
assign action ignore for ignore_all to 4017
assign action ignore for ignore_all to 4018
assign action ignore for ignore_all to 4019
assign action ignore for ignore_all to 4023
assign action ignore for ignore_all to 4026
assign action ignore for ignore_all to 4027
assign action ignore for ignore_all to 4028
assign action ignore for ignore_all to 4029
assign action ignore for ignore_all to 4030
assign action ignore for ignore_all to 4031
assign action ignore for ignore_all to 4032
assign action ignore for ignore_all to 4033
assign action ignore for ignore_all to 4034
assign action ignore for ignore_all to 4035
assign action ignore for ignore_all to 4036
assign action ignore for ignore_all to 4037
assign action ignore for ignore_all to 4038
assign action ignore for ignore_all to 4039
assign action ignore for ignore_all to 4040
assign action ignore for ignore_all to 4041
assign action ignore for ignore_all to 4042
assign action ignore for ignore_all to 4043
assign action ignore for ignore_all to 4044
assign action ignore for ignore_all to 4045
assign action ignore for ignore_all to 4046
assign action ignore for ignore_all to 4304
assign action ignore for ignore_all to 4407
assign action ignore for ignore_all to 4410
assign action ignore for ignore_all to 4419
assign action ignore for ignore_all to 4621
assign action ignore for ignore_all to 4622
assign action ignore for ignore_all to 4702
assign action ignore for ignore_all to 4704
assign action ignore for ignore_all to 4705
assign action ignore for ignore_all to 4707
assign action ignore for ignore_all to 4800
assign action ignore for ignore_all to 4829
assign action ignore for ignore_all to 4903
assign action ignore for ignore_all to 4904
assign action ignore for ignore_all to 4907
assign action ignore for ignore_all to 4908
assign action ignore for ignore_all to 5003
assign action ignore for ignore_all to 5005
assign action ignore for ignore_all to 5007
assign action ignore for ignore_all to 5010
assign action ignore for ignore_all to 5012
assign action ignore for ignore_all to 5018
assign action ignore for ignore_all to 5026
assign action ignore for ignore_all to 5027
assign action ignore for ignore_all to 5089
assign action ignore for ignore_all to 5110
assign action ignore for ignore_all to 5111
assign action ignore for ignore_all to 5112
assign action ignore for ignore_all to 5113
assign action ignore for ignore_all to 5121
assign action ignore for ignore_all to 5124
assign action ignore for ignore_all to 5135
assign action ignore for ignore_all to 5136
assign action ignore for ignore_all to 5140
assign action ignore for ignore_all to 5143
assign action ignore for ignore_all to 5147
assign action ignore for ignore_all to 5208
assign action ignore for ignore_all to 5701
assign action ignore for ignore_all to 5703
assign action ignore for ignore_all to 5704
assign action ignore for ignore_all to 5826
assign action ignore for ignore_all to 5827
assign action ignore for ignore_all to 5832
assign action ignore for ignore_all to 5836
assign action ignore for ignore_all to 5837
assign action ignore for ignore_all to 5838
assign action ignore for ignore_all to 5858
assign action ignore for ignore_all to 5866
assign action ignore for ignore_all to 5884
assign action ignore for ignore_all to 5898
assign action ignore for ignore_all to 6001
assign action ignore for ignore_all to 6005
assign action ignore for ignore_all to 6006
assign action ignore for ignore_all to 6201
assign action ignore for ignore_all to 6202
assign action ignore for ignore_all to 6203
assign action ignore for ignore_all to 6204
assign action ignore for ignore_all to 6205
assign action ignore for ignore_all to 6206
assign action ignore for ignore_all to 6207
assign action ignore for ignore_all to 6208
assign action ignore for ignore_all to 6209
assign action ignore for ignore_all to 6210
assign action ignore for ignore_all to 6211
assign action ignore for ignore_all to 6212
assign action ignore for ignore_all to 6213
assign action ignore for ignore_all to 6214
assign action ignore for ignore_all to 6215
assign action ignore for ignore_all to 6216
assign action ignore for ignore_all to 6217
assign action ignore for ignore_all to 6218
assign action ignore for ignore_all to 6219
assign action ignore for ignore_all to 6220
assign action ignore for ignore_all to 6221
assign action ignore for ignore_all to 6222
assign action ignore for ignore_all to 6223
assign action ignore for ignore_all to 6224
assign action ignore for ignore_all to 6225
assign action ignore for ignore_all to 6227
assign action ignore for ignore_all to 6228
assign action ignore for ignore_all to 6229
assign action ignore for ignore_all to 6230
assign action ignore for ignore_all to 6231
assign action ignore for ignore_all to 6232
assign action ignore for ignore_all to 6233
assign action ignore for ignore_all to 6234
assign action ignore for ignore_all to 6235
assign action ignore for ignore_all to 6236
assign action ignore for ignore_all to 6237
assign action ignore for ignore_all to 6238
assign action ignore for ignore_all to 6239
assign action ignore for ignore_all to 6240
assign action ignore for ignore_all to 6241
assign action ignore for ignore_all to 6242
assign action ignore for ignore_all to 6243
assign action ignore for ignore_all to 6244
assign action ignore for ignore_all to 6245
assign action ignore for ignore_all to 6246
assign action ignore for ignore_all to 6247
assign action ignore for ignore_all to 6248
assign action ignore for ignore_all to 6249
assign action ignore for ignore_all to 6250
assign action ignore for ignore_all to 6251
assign action ignore for ignore_all to 6252
assign action ignore for ignore_all to 6253
assign action ignore for ignore_all to 6254
assign action ignore for ignore_all to 6255
assign action ignore for ignore_all to 6256
assign action ignore for ignore_all to 6257
assign action ignore for ignore_all to 6268
assign action ignore for ignore_all to 6269
assign action ignore for ignore_all to 6270
assign action ignore for ignore_all to 6271
assign action ignore for ignore_all to 6272
assign action ignore for ignore_all to 6273
assign action ignore for ignore_all to 6274
assign action ignore for ignore_all to 6275
assign action ignore for ignore_all to 6276
assign action ignore for ignore_all to 6277
assign action ignore for ignore_all to 6278
assign action ignore for ignore_all to 6279
assign action ignore for ignore_all to 6280
assign action ignore for ignore_all to 6281
assign action ignore for ignore_all to 6282
assign action ignore for ignore_all to 6283
assign action ignore for ignore_all to 6284
assign action ignore for ignore_all to 6285
assign action ignore for ignore_all to 6286
assign action ignore for ignore_all to 6287
assign action ignore for ignore_all to 6288
assign action ignore for ignore_all to 6289
assign action ignore for ignore_all to 6290
assign action ignore for ignore_all to 6291
assign action ignore for ignore_all to 7012
assign action ignore for ignore_all to 7013
assign action ignore for ignore_all to 7014
assign action ignore for ignore_all to 7015
assign action ignore for ignore_all to 7110
assign action ignore for ignore_all to 7112
assign action ignore for ignore_all to 7140
assign action ignore for ignore_all to 7201
assign action ignore for ignore_all to 7202
assign action ignore for ignore_all to 7203
assign action ignore for ignore_all to 7206
assign action ignore for ignore_all to 7207
assign action ignore for ignore_all to 7208
assign action ignore for ignore_all to 7234
assign action ignore for ignore_all to 7337
assign action ignore for ignore_all to 7338
assign action ignore for ignore_all to 7339
assign action ignore for ignore_all to 7340
assign action ignore for ignore_all to 7341
assign action ignore for ignore_all to 7380
assign action ignore for ignore_all to 7381
assign action ignore for ignore_all to 7412
assign action ignore for ignore_all to 7413
assign action ignore for ignore_all to 7415
assign action ignore for ignore_all to 7770
assign action ignore for ignore_all to 7777
assign action ignore for ignore_all to 7783
assign action ignore for ignore_all to 7788
assign action ignore for ignore_all to 7904
assign action ignore for ignore_all to 7905
assign action ignore for ignore_all to 7906
assign action ignore for ignore_all to 7908
assign action ignore for ignore_all to 7910
assign action ignore for ignore_all to 7911
assign action ignore for ignore_all to 7912
assign action ignore for ignore_all to 7913
assign action ignore for ignore_all to 7916
assign action ignore for ignore_all to 7917
assign action ignore for ignore_all to 7918
assign action ignore for ignore_all to 7920
assign action ignore for ignore_all to 7922
assign action ignore for ignore_all to 7923
assign action ignore for ignore_all to 7924
assign action ignore for ignore_all to 7925
assign action ignore for ignore_all to 7926
assign action ignore for ignore_all to 7927
assign action ignore for ignore_all to 7929
assign action ignore for ignore_all to 7932
assign action ignore for ignore_all to 7933
assign action ignore for ignore_all to 7934
assign action ignore for ignore_all to 7942
assign action ignore for ignore_all to 7944
assign action ignore for ignore_all to 7945
assign action ignore for ignore_all to 7946
assign action ignore for ignore_all to 7947
assign action ignore for ignore_all to 7948
assign action ignore for ignore_all to 7954
assign action ignore for ignore_all to 7965
assign action ignore for ignore_all to 7970
assign action ignore for ignore_all to 7971
assign action ignore for ignore_all to 7972
assign action ignore for ignore_all to 7989
assign action ignore for ignore_all to 8001
assign action ignore for ignore_all to 8207
assign action ignore for ignore_all to 8214
assign action ignore for ignore_all to 8217
assign action ignore for ignore_all to 8218
assign action ignore for ignore_all to 8705
assign action ignore for ignore_all to 9109
assign action ignore for ignore_all to 9131
assign action ignore for ignore_all to 9137
assign action ignore for ignore_all to 9141
assign action ignore for ignore_all to 9142
assign action ignore for ignore_all to 9149
assign action ignore for ignore_all to 9318
assign action ignore for ignore_all to 9319
assign action ignore for ignore_all to 9332
assign action ignore for ignore_all to 9333
assign action ignore for ignore_all to 9334
assign action ignore for ignore_all to 9501
assign action ignore for ignore_all to 9506
assign action ignore for ignore_all to 9712
assign action ignore for ignore_all to 9713
assign action ignore for ignore_all to 9714
assign action ignore for ignore_all to 9715
assign action ignore for ignore_all to 9716
assign action ignore for ignore_all to 9717
assign action ignore for ignore_all to 9718
assign action ignore for ignore_all to 9719
assign action ignore for ignore_all to 9720
assign action ignore for ignore_all to 9721
assign action ignore for ignore_all to 9722
assign action ignore for ignore_all to 9723
assign action ignore for ignore_all to 9724
assign action ignore for ignore_all to 9725
assign action ignore for ignore_all to 9726
assign action ignore for ignore_all to 9727
assign action ignore for ignore_all to 9728
assign action ignore for ignore_all to 9729
assign action ignore for ignore_all to 9730
assign action ignore for ignore_all to 9731
assign action ignore for ignore_all to 9732
assign action ignore for ignore_all to 9801
assign action ignore for ignore_all to 9804
assign action ignore for ignore_all to 9806
assign action ignore for ignore_all to 9807
assign action ignore for ignore_all to 9808
assign action ignore for ignore_all to 9904
assign action ignore for ignore_all to 9905
assign action ignore for ignore_all to 9907
assign action ignore for ignore_all to 9909
assign action ignore for ignore_all to 9911
assign action ignore for ignore_all to 9912
assign action ignore for ignore_all to 9925
assign action ignore for ignore_all to 10201
assign action ignore for ignore_all to 10202
assign action ignore for ignore_all to 10203
assign action ignore for ignore_all to 10204
assign action ignore for ignore_all to 10205
assign action ignore for ignore_all to 10206
assign action ignore for ignore_all to 10207
assign action ignore for ignore_all to 10208
assign action ignore for ignore_all to 10209
assign action ignore for ignore_all to 10210
assign action ignore for ignore_all to 10211
assign action ignore for ignore_all to 10212
assign action ignore for ignore_all to 10213
assign action ignore for ignore_all to 10214
assign action ignore for ignore_all to 10401
assign action ignore for ignore_all to 10402
assign action ignore for ignore_all to 10403
assign action ignore for ignore_all to 10404
assign action ignore for ignore_all to 10405
assign action ignore for ignore_all to 10406
assign action ignore for ignore_all to 10407
assign action ignore for ignore_all to 10408
assign action ignore for ignore_all to 10409
assign action ignore for ignore_all to 10410
assign action ignore for ignore_all to 10411
assign action ignore for ignore_all to 10412
assign action ignore for ignore_all to 10413
assign action ignore for ignore_all to 10414
assign action ignore for ignore_all to 10415
assign action ignore for ignore_all to 10416
assign action ignore for ignore_all to 10417
assign action ignore for ignore_all to 10418
assign action ignore for ignore_all to 10419
assign action ignore for ignore_all to 10420
assign action ignore for ignore_all to 10421
assign action ignore for ignore_all to 10422
assign action ignore for ignore_all to 10423
assign action ignore for ignore_all to 10424
assign action ignore for ignore_all to 10425
assign action ignore for ignore_all to 10426
assign action ignore for ignore_all to 10427
assign action ignore for ignore_all to 10428
assign action ignore for ignore_all to 10429
assign action ignore for ignore_all to 10430
assign action ignore for ignore_all to 10431
assign action ignore for ignore_all to 10432
assign action ignore for ignore_all to 10433
assign action ignore for ignore_all to 10434
assign action ignore for ignore_all to 10435
assign action ignore for ignore_all to 10436
assign action ignore for ignore_all to 10437
assign action ignore for ignore_all to 10438
assign action ignore for ignore_all to 10439
assign action ignore for ignore_all to 10440
assign action ignore for ignore_all to 10441
assign action ignore for ignore_all to 10442
assign action ignore for ignore_all to 10443
assign action ignore for ignore_all to 10444
assign action ignore for ignore_all to 10445
assign action ignore for ignore_all to 10446
assign action ignore for ignore_all to 10447
assign action ignore for ignore_all to 10448
assign action ignore for ignore_all to 10449
assign action ignore for ignore_all to 10450
assign action ignore for ignore_all to 10451
assign action ignore for ignore_all to 10452
assign action ignore for ignore_all to 10453
assign action ignore for ignore_all to 10454
assign action ignore for ignore_all to 10455
assign action ignore for ignore_all to 10456
assign action ignore for ignore_all to 10457
assign action ignore for ignore_all to 10458
assign action ignore for ignore_all to 10459
assign action ignore for ignore_all to 10460
assign action ignore for ignore_all to 10461
assign action ignore for ignore_all to 10462
assign action ignore for ignore_all to 10463
assign action ignore for ignore_all to 10464
assign action ignore for ignore_all to 10465
assign action ignore for ignore_all to 10466
assign action ignore for ignore_all to 10467
assign action ignore for ignore_all to 10468
assign action ignore for ignore_all to 10469
assign action ignore for ignore_all to 10470
assign action ignore for ignore_all to 10471
assign action ignore for ignore_all to 10472
assign action ignore for ignore_all to 10473
assign action ignore for ignore_all to 10474
assign action ignore for ignore_all to 10475
assign action ignore for ignore_all to 10476
assign action ignore for ignore_all to 10477
assign action ignore for ignore_all to 10478
assign action ignore for ignore_all to 10479
assign action ignore for ignore_all to 10480
assign action ignore for ignore_all to 10481
assign action ignore for ignore_all to 10482
assign action ignore for ignore_all to 10483
assign action ignore for ignore_all to 13001
assign action ignore for ignore_all to 13002
assign action ignore for ignore_all to 13003
assign action ignore for ignore_all to 13004
assign action ignore for ignore_all to 13005
assign action ignore for ignore_all to 13006
assign action ignore for ignore_all to 13007
assign action ignore for ignore_all to 13008
assign action ignore for ignore_all to 13009
assign action ignore for ignore_all to 13010
assign action ignore for ignore_all to 13011
assign action ignore for ignore_all to 13012
assign action ignore for ignore_all to 13013
assign action ignore for ignore_all to 13014
assign action ignore for ignore_all to 13015
assign action ignore for ignore_all to 13016
assign action ignore for ignore_all to 13017
assign action ignore for ignore_all to 13018
assign action ignore for ignore_all to 13019
assign action ignore for ignore_all to 13020
assign action ignore for ignore_all to 13021
assign action ignore for ignore_all to 13022
assign action ignore for ignore_all to 13023
assign action ignore for ignore_all to 13024
assign action ignore for ignore_all to 13025
assign action ignore for ignore_all to 13026
assign action ignore for ignore_all to 13027
assign action ignore for ignore_all to 13028
assign action ignore for ignore_all to 13029
assign action ignore for ignore_all to 13030
assign action ignore for ignore_all to 13031
assign action ignore for ignore_all to 13032
assign action ignore for ignore_all to 13033
assign action ignore for ignore_all to 13034
assign action ignore for ignore_all to 13035
assign action ignore for ignore_all to 13036
assign action ignore for ignore_all to 13037
assign action ignore for ignore_all to 13038
assign action ignore for ignore_all to 13039
assign action ignore for ignore_all to 13040
assign action ignore for ignore_all to 13041
assign action ignore for ignore_all to 13042
assign action ignore for ignore_all to 13043
assign action ignore for ignore_all to 13044
assign action ignore for ignore_all to 13045
assign action ignore for ignore_all to 13046
assign action ignore for ignore_all to 13047
assign action ignore for ignore_all to 13048
assign action ignore for ignore_all to 13049
assign action ignore for ignore_all to 13050
assign action ignore for ignore_all to 13051
assign action ignore for ignore_all to 13052
assign action ignore for ignore_all to 13053
assign action ignore for ignore_all to 13054
assign action ignore for ignore_all to 13055
assign action ignore for ignore_all to 13056
assign action ignore for ignore_all to 13057
assign action ignore for ignore_all to 13058
assign action ignore for ignore_all to 13059
assign action ignore for ignore_all to 13060
assign action ignore for ignore_all to 13061
assign action ignore for ignore_all to 13062
assign action ignore for ignore_all to 13065
assign action ignore for ignore_all to 13066
assign action ignore for ignore_all to 13067
assign action ignore for ignore_all to 13068
assign action ignore for ignore_all to 13069
assign action ignore for ignore_all to 13070
assign action ignore for ignore_all to 13071
assign action ignore for ignore_all to 13072
assign action ignore for ignore_all to 13073
assign action ignore for ignore_all to 13074
assign action ignore for ignore_all to 13075
assign action ignore for ignore_all to 13076
assign action ignore for ignore_all to 13077
assign action ignore for ignore_all to 13078
assign action ignore for ignore_all to 13079
assign action ignore for ignore_all to 13080
assign action ignore for ignore_all to 13081
assign action ignore for ignore_all to 13082
assign action ignore for ignore_all to 13083
assign action ignore for ignore_all to 13084
assign action ignore for ignore_all to 13085
assign action ignore for ignore_all to 13086
assign action ignore for ignore_all to 13087
assign action ignore for ignore_all to 13088
assign action ignore for ignore_all to 13089
assign action ignore for ignore_all to 13090
assign action ignore for ignore_all to 13091
assign action ignore for ignore_all to 13092
assign action ignore for ignore_all to 13093
assign action ignore for ignore_all to 13094
assign action ignore for ignore_all to 13095
assign action ignore for ignore_all to 13096
assign action ignore for ignore_all to 13097
assign action ignore for ignore_all to 13098
assign action ignore for ignore_all to 13099
assign action ignore for ignore_all to 13100
assign action ignore for ignore_all to 13101
assign action ignore for ignore_all to 13102
assign action ignore for ignore_all to 13103
assign action ignore for ignore_all to 13104
assign action ignore for ignore_all to 13105
assign action ignore for ignore_all to 13106
assign action ignore for ignore_all to 13107
assign action ignore for ignore_all to 13108
assign action ignore for ignore_all to 13109
assign action ignore for ignore_all to 13110
assign action ignore for ignore_all to 13111
assign action ignore for ignore_all to 13112
assign action ignore for ignore_all to 13113
assign action ignore for ignore_all to 13114
assign action ignore for ignore_all to 13115
assign action ignore for ignore_all to 13116
assign action ignore for ignore_all to 13117
assign action ignore for ignore_all to 13118
assign action ignore for ignore_all to 13119
assign action ignore for ignore_all to 13120
assign action ignore for ignore_all to 17027
assign action ignore for ignore_all to 17028
assign action ignore for ignore_all to 17029
assign action ignore for ignore_all to 17030
assign action ignore for ignore_all to 17031
assign action ignore for ignore_all to 17032
assign action ignore for ignore_all to 17033
assign action ignore for ignore_all to 17034
assign action ignore for ignore_all to 17035
assign action ignore for ignore_all to 17036
assign action ignore for ignore_all to 17037
assign action ignore for ignore_all to 17038
assign action ignore for ignore_all to 17039
assign action ignore for ignore_all to 17040
assign action ignore for ignore_all to 17041
assign action ignore for ignore_all to 17042
assign action ignore for ignore_all to 17043
assign action ignore for ignore_all to 17044
assign action ignore for ignore_all to 17045
assign action ignore for ignore_all to 17046
assign action ignore for ignore_all to 17047
assign action ignore for ignore_all to 17048
assign action ignore for ignore_all to 17050
assign action ignore for ignore_all to 17051
assign action ignore for ignore_all to 17052
assign action ignore for ignore_all to 17053
assign action ignore for ignore_all to 17054
assign action ignore for ignore_all to 17055
assign action ignore for ignore_all to 17056
assign action ignore for ignore_all to 17057
assign action ignore for ignore_all to 17058
assign action ignore for ignore_all to 17059
assign action ignore for ignore_all to 17060
assign action ignore for ignore_all to 17061
assign action ignore for ignore_all to 17062
assign action ignore for ignore_all to 17063
assign action ignore for ignore_all to 17064
assign action ignore for ignore_all to 17065
assign action ignore for ignore_all to 17066
assign action ignore for ignore_all to 17067
assign action ignore for ignore_all to 17068
assign action ignore for ignore_all to 17069
assign action ignore for ignore_all to 17070
assign action ignore for ignore_all to 17075
assign action ignore for ignore_all to 17080
assign action ignore for ignore_all to 17081
assign action ignore for ignore_all to 17082
assign action ignore for ignore_all to 17083
assign action ignore for ignore_all to 17084
assign action ignore for ignore_all to 17085
assign action ignore for ignore_all to 17086
assign action ignore for ignore_all to 17087
assign action ignore for ignore_all to 17088
assign action ignore for ignore_all to 17089
assign action ignore for ignore_all to 17090
assign action ignore for ignore_all to 17091
assign action ignore for ignore_all to 17100
assign action ignore for ignore_all to 17101
assign action ignore for ignore_all to 17102
assign action ignore for ignore_all to 17103
assign action ignore for ignore_all to 17104
assign action ignore for ignore_all to 17105
assign action ignore for ignore_all to 17106
assign action ignore for ignore_all to 17110
assign action ignore for ignore_all to 17111
assign action ignore for ignore_all to 17112
assign action ignore for ignore_all to 17120
assign action ignore for ignore_all to 17121
assign action ignore for ignore_all to 17122
assign action ignore for ignore_all to 17123
assign action ignore for ignore_all to 17124
assign action ignore for ignore_all to 17125
assign action ignore for ignore_all to 17126
assign action ignore for ignore_all to 17127
assign action ignore for ignore_all to 17128
assign action ignore for ignore_all to 17129
assign action ignore for ignore_all to 17130
assign action ignore for ignore_all to 17131
assign action ignore for ignore_all to 17132
assign action ignore for ignore_all to 17133
assign action ignore for ignore_all to 17134
assign action ignore for ignore_all to 17135
assign action ignore for ignore_all to 17136
assign action ignore for ignore_all to 17137
assign action ignore for ignore_all to 17138
assign action ignore for ignore_all to 17139
assign action ignore for ignore_all to 17140
assign action ignore for ignore_all to 17141
assign action ignore for ignore_all to 17142
assign action ignore for ignore_all to 17143
assign action ignore for ignore_all to 17144
assign action ignore for ignore_all to 17145
assign action ignore for ignore_all to 17146
assign action ignore for ignore_all to 17147
assign action ignore for ignore_all to 17214
assign action ignore for ignore_all to 17221
assign action ignore for ignore_all to 17235
assign action ignore for ignore_all to 17243
assign action ignore for ignore_all to 17255
assign action ignore for ignore_all to 17264
assign action ignore for ignore_all to 17273
assign action ignore for ignore_all to 17276
assign action ignore for ignore_all to 17287
assign action ignore for ignore_all to 17289
assign action ignore for ignore_all to 17291
assign action ignore for ignore_all to 17293
assign action ignore for ignore_all to 17294
assign action ignore for ignore_all to 17295
assign action ignore for ignore_all to 17300
assign action ignore for ignore_all to 17309
assign action ignore for ignore_all to 17319
assign action ignore for ignore_all to 17320
assign action ignore for ignore_all to 17321
assign action ignore for ignore_all to 17324
assign action ignore for ignore_all to 17335
assign action ignore for ignore_all to 17341
assign action ignore for ignore_all to 17345
assign action ignore for ignore_all to 17347
assign action ignore for ignore_all to 17348
assign action ignore for ignore_all to 17351
assign action ignore for ignore_all to 17354
assign action ignore for ignore_all to 17356
assign action ignore for ignore_all to 17357
assign action ignore for ignore_all to 17364
assign action ignore for ignore_all to 17365
assign action ignore for ignore_all to 17366
assign action ignore for ignore_all to 17370
assign action ignore for ignore_all to 17402
assign action ignore for ignore_all to 17416
assign action ignore for ignore_all to 17419
assign action ignore for ignore_all to 17420
assign action ignore for ignore_all to 17423
assign action ignore for ignore_all to 17430
assign action ignore for ignore_all to 17431
assign action ignore for ignore_all to 17432
assign action ignore for ignore_all to 17433
assign action ignore for ignore_all to 17434
assign action ignore for ignore_all to 17442
assign action ignore for ignore_all to 17452
assign action ignore for ignore_all to 17462
assign action ignore for ignore_all to 17463
assign action ignore for ignore_all to 17464
assign action ignore for ignore_all to 17472
assign action ignore for ignore_all to 17480
assign action ignore for ignore_all to 17483
assign action ignore for ignore_all to 17489
assign action ignore for ignore_all to 17490
assign action ignore for ignore_all to 17495
assign action ignore for ignore_all to 17496
assign action ignore for ignore_all to 17500
assign action ignore for ignore_all to 17502
assign action ignore for ignore_all to 17507
assign action ignore for ignore_all to 17511
assign action ignore for ignore_all to 17512
assign action ignore for ignore_all to 17525
assign action ignore for ignore_all to 17526
assign action ignore for ignore_all to 17527
assign action ignore for ignore_all to 17528
assign action ignore for ignore_all to 17531
assign action ignore for ignore_all to 17532
assign action ignore for ignore_all to 17533
assign action ignore for ignore_all to 17542
assign action ignore for ignore_all to 17547
assign action ignore for ignore_all to 17548
assign action ignore for ignore_all to 17550
assign action ignore for ignore_all to 17551
assign action ignore for ignore_all to 17552
assign action ignore for ignore_all to 17567
assign action ignore for ignore_all to 17570
assign action ignore for ignore_all to 17571
assign action ignore for ignore_all to 17591
assign action ignore for ignore_all to 17592
assign action ignore for ignore_all to 17594
assign action ignore for ignore_all to 17611
assign action ignore for ignore_all to 17612
assign action ignore for ignore_all to 17613
assign action ignore for ignore_all to 17614
assign action ignore for ignore_all to 17615
assign action ignore for ignore_all to 17616
assign action ignore for ignore_all to 17617
assign action ignore for ignore_all to 17619
assign action ignore for ignore_all to 17620
assign action ignore for ignore_all to 17661
assign action ignore for ignore_all to 17662
assign action ignore for ignore_all to 17671
assign action ignore for ignore_all to 17672
assign action ignore for ignore_all to 17673
assign action ignore for ignore_all to 17677
assign action ignore for ignore_all to 17686
assign action ignore for ignore_all to 17687
assign action ignore for ignore_all to 17690
assign action ignore for ignore_all to 17691
assign action ignore for ignore_all to 17692
assign action ignore for ignore_all to 17693
assign action ignore for ignore_all to 17694
assign action ignore for ignore_all to 17700
assign action ignore for ignore_all to 17710
assign action ignore for ignore_all to 17711
assign action ignore for ignore_all to 17714
assign action ignore for ignore_all to 17715
assign action ignore for ignore_all to 17721
assign action ignore for ignore_all to 17735
assign action ignore for ignore_all to 17750
assign action ignore for ignore_all to 17762
assign action ignore for ignore_all to 17770
assign action ignore for ignore_all to 17772
assign action ignore for ignore_all to 17777
assign action ignore for ignore_all to 17778
assign action ignore for ignore_all to 17781
assign action ignore for ignore_all to 17784
assign action ignore for ignore_all to 17789
assign action ignore for ignore_all to 17794
assign action ignore for ignore_all to 17796
assign action ignore for ignore_all to 17801
assign action ignore for ignore_all to 17807
assign action ignore for ignore_all to 17810
assign action ignore for ignore_all to 17811
assign action ignore for ignore_all to 17830
assign action ignore for ignore_all to 17831
assign action ignore for ignore_all to 17832
assign action ignore for ignore_all to 17841
assign action ignore for ignore_all to 17846
assign action ignore for ignore_all to 17847
assign action ignore for ignore_all to 17850
assign action ignore for ignore_all to 17853
assign action ignore for ignore_all to 17854
assign action ignore for ignore_all to 17860
assign action ignore for ignore_all to 17861
assign action ignore for ignore_all to 17864
assign action ignore for ignore_all to 17865
assign action ignore for ignore_all to 17873
assign action ignore for ignore_all to 17876
assign action ignore for ignore_all to 17885
assign action ignore for ignore_all to 17886
assign action ignore for ignore_all to 17897
assign action ignore for ignore_all to 17900
assign action ignore for ignore_all to 17906
assign action ignore for ignore_all to 17913
assign action ignore for ignore_all to 17914
assign action ignore for ignore_all to 17915
assign action ignore for ignore_all to 17918
assign action ignore for ignore_all to 17919
assign action ignore for ignore_all to 17926
assign action ignore for ignore_all to 17942
assign action ignore for ignore_all to 17943
assign action ignore for ignore_all to 17944
assign action ignore for ignore_all to 17945
assign action ignore for ignore_all to 17946
assign action ignore for ignore_all to 17947
assign action ignore for ignore_all to 17948
assign action ignore for ignore_all to 17949
assign action ignore for ignore_all to 17950
assign action ignore for ignore_all to 17951
assign action ignore for ignore_all to 17961
assign action ignore for ignore_all to 17962
assign action ignore for ignore_all to 17964
assign action ignore for ignore_all to 17965
assign action ignore for ignore_all to 17970
assign action ignore for ignore_all to 17971
assign action ignore for ignore_all to 17972
assign action ignore for ignore_all to 17978
assign action ignore for ignore_all to 17982
assign action ignore for ignore_all to 17983
assign action ignore for ignore_all to 17986
assign action ignore for ignore_all to 17988
assign action ignore for ignore_all to 17989
assign action ignore for ignore_all to 17990
assign action ignore for ignore_all to 17991
assign action ignore for ignore_all to 17998
assign action ignore for ignore_all to 17999
assign action ignore for ignore_all to 18000
assign action ignore for ignore_all to 18006
assign action ignore for ignore_all to 18007
assign action ignore for ignore_all to 18008
assign action ignore for ignore_all to 18009
assign action ignore for ignore_all to 18018
assign action ignore for ignore_all to 18020
assign action ignore for ignore_all to 18028
assign action ignore for ignore_all to 18029
assign action ignore for ignore_all to 18036
assign action ignore for ignore_all to 18037
assign action ignore for ignore_all to 18038
assign action ignore for ignore_all to 18049
assign action ignore for ignore_all to 18050
assign action ignore for ignore_all to 18051
assign action ignore for ignore_all to 18052
assign action ignore for ignore_all to 18053
assign action ignore for ignore_all to 18058
assign action ignore for ignore_all to 18061
assign action ignore for ignore_all to 18062
assign action ignore for ignore_all to 18063
assign action ignore for ignore_all to 18067
assign action ignore for ignore_all to 18069
assign action ignore for ignore_all to 18070
assign action ignore for ignore_all to 18071
assign action ignore for ignore_all to 18077
assign action ignore for ignore_all to 18078
assign action ignore for ignore_all to 18079
assign action ignore for ignore_all to 18080
assign action ignore for ignore_all to 18084
assign action ignore for ignore_all to 18099
assign action ignore for ignore_all to 18100
assign action ignore for ignore_all to 18104
assign action ignore for ignore_all to 18105
assign action ignore for ignore_all to 18108
assign action ignore for ignore_all to 18109
assign action ignore for ignore_all to 18111
assign action ignore for ignore_all to 18112
assign action ignore for ignore_all to 18113
assign action ignore for ignore_all to 18116
assign action ignore for ignore_all to 18119
assign action ignore for ignore_all to 18120
assign action ignore for ignore_all to 18122
assign action ignore for ignore_all to 18129
assign action ignore for ignore_all to 18132
assign action ignore for ignore_all to 18145
assign action ignore for ignore_all to 18151
assign action ignore for ignore_all to 18153
assign action ignore for ignore_all to 18156
assign action ignore for ignore_all to 18165
assign action ignore for ignore_all to 18167
assign action ignore for ignore_all to 18170
assign action ignore for ignore_all to 18172
assign action ignore for ignore_all to 18176
assign action ignore for ignore_all to 18177
assign action ignore for ignore_all to 18540
assign action ignore for ignore_all to 18543
assign action ignore for ignore_all to 20001
assign action ignore for ignore_all to 100701
assign action ignore for ignore_all to 101801
assign action ignore for ignore_all to 102501
assign action ignore for ignore_all to 102601
assign action ignore for ignore_all to 102701
assign action ignore for ignore_all to 103401
assign action ignore for ignore_all to 103601
assign action ignore for ignore_all to 104401
assign action ignore for ignore_all to 104501
assign action ignore for ignore_all to 104601
assign action ignore for ignore_all to 104701
assign action ignore for ignore_all to 105201
assign action ignore for ignore_all to 300601
assign action ignore for ignore_all to 304201
assign action ignore for ignore_all to 304301
assign action ignore for ignore_all to 304501
assign action ignore for ignore_all to 304801
assign action ignore for ignore_all to 305401
assign action ignore for ignore_all to 402201
assign action ignore for ignore_all to 403401
assign action ignore for ignore_all to 403501
assign action ignore for ignore_all to 403601
assign action ignore for ignore_all to 403701
assign action ignore for ignore_all to 403801
assign action ignore for ignore_all to 403901
assign action ignore for ignore_all to 404101
assign action ignore for ignore_all to 405801
assign action ignore for ignore_all to 408401
assign action ignore for ignore_all to 408501
assign action ignore for ignore_all to 602801
assign action ignore for ignore_all to 602901
assign action ignore for ignore_all to 603001
assign action ignore for ignore_all to 603801
assign action ignore for ignore_all to 604101
assign action ignore for ignore_all to 604501
assign action ignore for ignore_all to 604601
assign action ignore for ignore_all to 604701
assign action ignore for ignore_all to 604801
assign action ignore for ignore_all to 604901
assign action ignore for ignore_all to 605001
assign action ignore for ignore_all to 605101
assign action ignore for ignore_all to 605201
assign action ignore for ignore_all to 605301
assign action ignore for ignore_all to 605401
assign action ignore for ignore_all to 605501
assign action ignore for ignore_all to 607801
go
assign action ignore for ignore_all to 7747
go
assign action ignore for ignore_all to 208
go
assign action ignore for ignore_all to 207
go

Finally alter the connection to use the new error class using alter connection command on Replication server

Understanding Sybase Page Architecture

1. The databases stockpiling are partitioned into assignment units. Designation units are stockpiles containing 256 information pages. Therefore implying that there will be one column of one degree ( 8 pages/push ). In this manner giving us an aggregate of 32 lines in a distribution unit. Every line has 8 pages or 1 degree. A question has the least space apportioned as one degree

2. The primary page of every designation unit ( 0, 256 … numbers ) are the allotment pages for the portion unit which contain data of the items and individual pages apportioned to the articles which are having pages allotted in that assignment unit.

3. The GAM is the worldwide allotment delineate which is containing a bitmap of the portion units per database. On the off chance that a portion unit is having no free degree then it will demonstrate bitmap esteem 1.

4. The OAM is the question allotment outline which is the primary page of the apportioned pages for a protest and this page essentially indicates the distribution pages which contain the items page designation data. Accordingly, this essentially indicates the portion unit's allotment page which has its data about page designation.

Along these lines to finish up 1 distribution unit - 32 lines - 8 pages for every column - 1 degree for each line. Page(0), Page(256) , Page (512) are the assignment pages. These are referenced by OAM pages of the items which really have pages in the designation units.

Assume a question is put away in 3 degrees. 2 degrees in allotment unit 1 and 1 degree in portion unit 2. At that point, Allocation page of AU1 and AU2 will contain data of the protest id and the degrees possessed in the separate portion units. In this way, the OAM of the protest will make references to designation page of AU1 and AU2.

Replication Server Thread Flow

Sybase Dump verification

TAKEN DUMP
1> load database pm from '/OracleDumps/opctlsy2/pm.verific.dmp' with headeronly
2>
Backup Server session id is: 14. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Backup Server: 6.28.1.1: Dumpfile name 'pm100050E6BD ' section number 1 mounted on disk file '/OracleDumps/opctlsy2/pm.verific.dmp'
This is a database dump of database ID 4, name 'pm', from Jan 5 2010 4:24PM. ASE version: Adaptive Server Enterprise/15.0.2/EBF 14328/P/Sun_svr4/OS 5.8/ase1502/2486/64-bit/FBO/Thu May 24 12:. Backup Server version: Backup Server/15.0.2/Sun_svr4/OS 5.8/ase1502/2902/32-bit/OPT/Thu May 24 08:04:12 2007. Database page size is 2048.
Database contains 15360 pages; checkpoint RID=(Rid pageid = 0x7e0; row num = 0x2); next object ID=1801054421; sort order ID=50, status=0; charset ID=1.
Database log version=7; database upgrade version=35.
segmap: 0x00000007 lstart=0 vstart=[vpgdevno=8 vpvpn=0] lsize=5120 unrsvd=3546
segmap: 0x00000007 lstart=5120 vstart=[vpgdevno=23 vpvpn=0] lsize=10240 unrsvd=10193
1> load database pm from '/OracleDumps/opctlsy2/pm.verific.dmp' with listonly
2>
Backup Server session id is: 16. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Backup Server: 4.34.1.1: Device '/OracleDumps/opctlsy2/pm.verific.dmp':
Volume name:' '
Backup Server: 4.36.1.1: Device '/OracleDumps/opctlsy2/pm.verific.dmp':
File name: 'pm100050E6BD '
Create date & time: Tuesday, Jan 5, 2010, 16:24:29
Expiration date & time: Tuesday, Jan 5, 2010, 00:00:00
Database name: 'pm '
Backup Server: 6.30.1.3: Device /OracleDumps/opctlsy2/pm.verific.dmp: Volume cataloguing complete.
1> load database pm from '/OracleDumps/opctlsy2/pm.verific.dmp' with listonly=full
2>
Backup Server session id is: 18. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Backup Server: 4.35.1.1: Device '/OracleDumps/opctlsy2/pm.verific.dmp':
Label name: 'VOL1'
Volume id: ' '
Access code: ' '
Reserved: ' '
Compression level: '0'
Owner id: ' '
Reserved: ' '
Labeling version: 7
Backup Server: 4.37.1.1: Device '/OracleDumps/opctlsy2/pm.verific.dmp':
Label id: 'HDR1'
File name: 'pm100050E6BD '
Stripe count: 1
Device typecount: 1
Archive volume number: 1
Stripe position: 0
Generation number: 0001
Generation version: 00
Backup Server: 4.148.1.1:
Create date & time: Tuesday, Jan 5, 2010, 16:24:29
Expiration date & time: Tuesday, Jan 5, 2010, 00:00:00
Access code: ' '
File block count: 0
Sybase id string: 'Sybase '
Reserved: ' '
Backup Server: 4.174.1.1: Device '/OracleDumps/opctlsy2/pm.verific.dmp':
Label id: 'HDR2'
Record format: 'F'
Max. bytes/block: 65536
Record length: 02048
Backup format version: 03
Reserved: ' B'
Database name: 'pm '
Buffer offset length: 00
Async. database I/Os: '000000002'
Max. database I/O size: '0000128'
Number of I/O Buffers: '03'
database page size in KiloBytes: '0000002'
Reserved: ' '
Backup Server: 4.37.1.1: Device '/OracleDumps/opctlsy2/pm.verific.dmp':
Label id: 'EOF1'
File name: 'pm100050E6BD '
Stripe count: 1
Device typecount: 1
Archive volume number: 1
Stripe position: 0
Generation number: 0001
Generation version: 00
Backup Server: 4.148.1.1:
Create date & time: Tuesday, Jan 5, 2010, 16:24:29
Expiration date & time: Tuesday, Jan 5, 2010, 00:00:00
Access code: ' '
File block count: 1483
Sybase id string: 'Sybase '
Reserved: ' '
Backup Server: 4.174.1.1: Device '/OracleDumps/opctlsy2/pm.verific.dmp':
Label id: 'EOF2'
Record format: 'F'
Max. bytes/block: 65536
Record length: 02048
Backup format version: 03
Reserved: ' B'
Database name: 'pm '
Buffer offset length: 00
Async. database I/Os: '000000002'
Max. database I/O size: '0000128'
Number of I/O Buffers: '03'
database page size in KiloBytes: '0000002'
Reserved: ' '
Backup Server: 4.154.1.1: Device '/OracleDumps/opctlsy2/pm.verific.dmp':
Label id: 'EOF3'
Total data stored on the volume: 2966 KiloBytes
Backup Server: 6.30.1.3: Device /OracleDumps/opctlsy2/pm.verific.dmp: Volume cataloguing complete.
CORRUPTED THE DUMP ;)
1> load database pm from '/OracleDumps/opctlsy2/pm.verific.dmp' with headeronly
2>
Backup Server session id is: 21. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Backup Server: 4.12.2.1: Label validation error: HDR1 label not found.
Backup Server: 6.31.2.4: Volume rejected.
Backup Server: 1.14.2.2: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
Backup Server: 6.32.2.3: /OracleDumps/opctlsy2/pm.verific.dmp: volume not valid or not requested (server: , session id: 21.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
Msg 8009, Level 16, State 1:
Server 'GALLARDO', Line 1:
Error encountered by Backup Server. Please refer to Backup Server messages for details.
1> load database pm from '/OracleDumps/opctlsy2/pm.verific.dmp' with listonly
2>
Backup Server session id is: 23. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Backup Server: 4.12.2.1: Label validation error: HDR1 label not found.
Backup Server: 6.31.2.4: Volume rejected.
Backup Server: 6.32.2.3: /OracleDumps/opctlsy2/pm.verific.dmp: volume not valid or not requested (server: , session id: 23.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.
1> load database pm from '/OracleDumps/opctlsy2/pm.verific.dmp' with listonly = full
2>
Backup Server session id is: 25. Use this value when executing the 'sp_volchanged' system stored procedure after fulfilling any volume change request from the Backup Server.
Backup Server: 4.12.2.1: Label validation error: HDR1 label not found.
Backup Server: 6.31.2.4: Volume rejected.
Backup Server: 6.32.2.3: /OracleDumps/opctlsy2/pm.verific.dmp: volume not valid or not requested (server: , session id: 25.)
Backup Server: 1.14.2.4: Unrecoverable I/O or volume error. This DUMP or LOAD session must exit.

Mount Unmount databases in Sybase

1> unmount database mydb to '/OracleDumps/opctlsy2/sybase/mydb.mnfst'
2>
00:00000:00011:2008/07/29 17:02:43.76 kernel Deactivating virtual device 1, '/OracleDumps/opctlsy2/sybase/data/mdev.dat'.
00:00000:00011:2008/07/29 17:02:43.76 kernel Deactivating virtual device 3, '/OracleDumps/opctlsy2/sybase/data/mdev1.dat'.
1> 1>
1>
Password:
Msg 2401, Level 11, State 2:
Character set conversion is not available between client character set 'iso_1' and server character set 'ascii_8'.
No conversions will be done.

1> sp_helpdb
2>
name db_size owner dbid created status
-------------- ------------- ----- ----- ------------ --------------------------------------------------------------------
master 99.5 MB sa 1 Jan 01, 1900 mixed log and data
model 3.0 MB sa 3 Jan 01, 1900 mixed log and data
sybsystemdb 3.0 MB sa 31513 Jul 16, 2008 mixed log and data
sybsystemprocs 170.0 MB sa 31514 Feb 19, 2008 trunc log on chkpt, mixed log and data
tempdb 4.0 MB sa 2 Jul 29, 2008 select into/bulkcopy/pllsort, trunc log on chkpt, mixed log and data
(1 row affected)
(return status = 0)
1> mount database all from '/OracleDumps/opctlsy2/sybase/mydb.mnfst'
2>
00:00000:00012:2008/07/29 17:04:17.36 kernel Initializing virtual device 1, '/OracleDumps/opctlsy2/sybase/data/mdev.dat' with dsync 'on'.
00:00000:00012:2008/07/29 17:04:17.36 kernel Virtual device 1 started using asynchronous i/o.
00:00000:00012:2008/07/29 17:04:17.36 kernel Initializing virtual device 3, '/OracleDumps/opctlsy2/sybase/data/mdev1.dat' with dsync 'on'.
00:00000:00012:2008/07/29 17:04:17.36 kernel Virtual device 3 started using asynchronous i/o.
00:00000:00012:2008/07/29 17:04:17.37 server Log contains all committed transactions until 2008/07/29 16:55:49.67 for database mydb.
Started estimating recovery log boundaries for database 'mydb'.
Database 'mydb', checkpoint=(2567, 13), first=(2567, 13), last=(2567, 13).
Completed estimating recovery log boundaries for database 'mydb'.
Started ANALYSIS pass for database 'mydb'.
Completed ANALYSIS pass for database 'mydb'.
Started REDO pass for database 'mydb'. The total number of log records to process is 1.
Completed REDO pass for database 'mydb'.
Recovery of database 'mydb' will undo incomplete nested top actions.
Started recovery checkpoint for database 'mydb'.
Completed recovery checkpoint for database 'mydb'.
Started filling free space info for database 'mydb'.
Completed filling free space info for database 'mydb'.
Started cleaning up the default data cache for database 'mydb'.
Completed cleaning up the default data cache for database 'mydb'.
MOUNT DATABASE: Completed recovery of mounted database 'mydb'.
1> sp_helpdb
2>
name db_size owner dbid created status
-------------- ------------- ----- ----- ------------ --------------------------------------------------------------------
master 99.5 MB sa 1 Jan 01, 1900 mixed log and data
model 3.0 MB sa 3 Jan 01, 1900 mixed log and data
mydb 10.0 MB sa 4 Jul 29, 2008 offline
sybsystemdb 3.0 MB sa 31513 Jul 16, 2008 mixed log and data
sybsystemprocs 170.0 MB sa 31514 Feb 19, 2008 trunc log on chkpt, mixed log and data
tempdb 4.0 MB sa 2 Jul 29, 2008 select into/bulkcopy/pllsort, trunc log on chkpt, mixed log and data
(1 row affected)
(return status = 0)
1>