Unsolved
This post is more than 5 years old
12 Posts
0
1567
April 9th, 2013 22:00
Query regarding restore using Networker Module for MS SQL
Hi All,
We have set up jobs to take backup of MS SQL and file system. When we try to restore file system using Networker User, we see the folders which have been backed up by NMC, which is absolutely fine. When we try to restore database using Networker Module for MS SQL, we see those databases which are backed by NMC, which is also fine. But when we start restore using Networker Module for MS SQL, it again backs up the database and using that backup it restores. We can see files created for that particular time in the respective folder. What we want to achieve is to restore the database using backup created by NMC. Is it possible? Can anybody provide inputs regarding this? Same thing does not happen when we restore file system.
Thanks for your inputs.
Thanks,
Shilpa
ble1
2 Intern
•
14.3K Posts
0
April 10th, 2013 00:00
Is it whole database or just transaction log that get's backed up? Check Restore a Database Backup which in first note explains why this happens. As for what to restore, you control that via browsing mechanism. In restore options you also see:
As you can see, by default action of backing up transaction logs is enabled there...
Shilpa_Am
12 Posts
0
April 10th, 2013 05:00
Hi Hrvoje,
When I do the backup I see that 4 files are created. When I do the restore I see that 2 files are created. The sizes of these 2 files are same as sizes of 2 files among 4 files created by backup. Could you please explain how I can be sure that only database or transaction logs are backed up when I do the restore? I see that ''Trasaction log backup before restoring Microsoft SQL Server 2005 and newer databases' option is selected. But this is what I see in 'Restore Status' window.
Recovering files of client 'myshec234308d.mycompany' from server 'MYSHEC234308D.mycompany' to client 'MYSHEC234308D\DOCUMENTUMDB'.
43708:(pid 3868):Start time: Wed Apr 10 17:14:58 2013
43621:(pid 3868):Computer Name: MYSHEC234308D User Name: sysadmin
37790:(pid 3868):Database bam_documentum_bam backup level forced to full
NSR_BACKUP_LEVEL: full;
NSR_DATA_VOLUME_POOL: Default;
NSR_SAVESET_NAME: "MSSQL$DOCUMENTUMDB:bam_documentum_bam";
NSR_SERVER: MYSHEC234308D.mycompany;
37994:(pid 3868):Backing up bam_documentum_bam...
4690:(pid 3868):BACKUP database [bam_documentum_bam] TO virtual_device='Legato#09a86b44-1f6e-4faa-9e14-741956d04812' WITH name=N'LegatoNWMSQL'
53085:(pid 3868):Backing up of bam_documentum_bam succeeded.
nsrsqlsv: MSSQL$DOCUMENTUMDB:bam_documentum_bam level=full, 43 MB 00:00:08 1 file(s)
43709:(pid 3868):Stop time: Wed Apr 10 17:15:10 2013
Backup completion time: Wed Apr 10 17:15:11 2013
43708:(pid 6064):Start time: Wed Apr 10 17:15:14 2013
43621:(pid 6064):Computer Name: MYSHEC234308D User Name: sysadmin
NSR_CLIENT: MYSHEC234308D.mycompany;
NSR_SERVER: MYSHEC234308D.mycompany;
37721:(pid 6064):Recovering database 'bam_documentum_bam' ...
4690:(pid 6064):RESTORE database [bam_documentum_bam] FROM virtual_device='Legato#6ac03968-6346-4500-92f9-20d4e370d5a7'
35866:(pid 6064):The restore of database 'bam_documentum_bam' completed successfully.
29309:(pid 6064):
Received 43 MB 1 item(s) from NSR server.
43709:(pid 6064):Stop time: Wed Apr 10 17:15:51 2013
Restore completion time: Wed Apr 10 17:15:53 2013
It says backup of database is succe
ded.
Also, when I do the backup of a different database, 4 files are created.
3999617102.0 - Backup of bam_documentum_bam database
3982839889.0 - Backup of bam_documentum_bam database
3966062682.0 - Backup of bam_documentum_bam database
3949285470.0 - Backup of bam_documentum_bam database
3932508351.0 - Restore of bam_documentum_bam database
3915731141.0 - Restore of bam_documentum_bam database
3898955005.0 - Backup of db_documentum database
3882177944.0 - Backup of db_documentum database
3865400736.0 - Backup of db_documentum database
3848623525.0 - Backup of db_documentum database
3831847009.0 - Restore of db_documentum database
3815069953.0 - Restore of db_documentum database
The file of size 44,256 KB created during backup and recovery of bam_documentum_bam is created twice. If we assume that transaction logs are backed up during recovery also, then size of transaction log should be 44,256 KB.
But file of same size is not created during backup and recovery of db_documentum database. Also in our case db_documentum database is big. By looking at file size, it seems that database is getting backed up again.Because file of size 1,189,984 KB is created twice.
Any ideas on this?
Please let me know.
Thanks,
Shilpa
ble1
2 Intern
•
14.3K Posts
0
April 10th, 2013 06:00
I see that backup request was pushed to full - are you sure DB is not SIMPLE mode? To see what is backed up, use mminfo and nsrinfo to obtain data and not look at files. With mminfo find nsavetime for your backup and feed it against nsrinfo for mssql namespace and you should get the data. Also, you should see some more data from nsrsqlsv logs.