I wud really appreciate if any1 can clarify these concepts
Can a file group be restored from file group bckup..? -ie. primary group from last full backup and requried file grp from latest file group +log bckup
or it has to full bckp every time to restore a single file group ...?
I knw its stupid to ask this but the redbook sg246148 states "You can perform partial restores only on full database backup objects." got confused with this sentence, If its so, then wat is the point in takin file group backups..?
------------
Wat shoud be the command, i m using cli becoz GUI relocate doesnt work for file grop restores (TSM version 5.4.5)
Our requirement is to perform, a single file group backup and restore the same wen required.
Shoud the command be : Tdpsqlc db_name FULL OR it is '"Tdpsqlc db_name Group=filegroup_name
Should I use /groups=.... as well ---Plz send me the command
--------------------------------------------
tdpsqlc rest Database_Name full
/fromsqlserver=Original_sqlserver
/sqlserver=Destined_SQLserver
/partial /groups=TERTIARY
/tsmoptfile=001.opt
/configfile=001.cfg
/tsmnode=node_SQL /tsmpassword=pwd /into=new_db
/relocate=Primary_File-Grp,Required-File-Grp,Log-File-Grp
/to=x:\blah\blah.mdf,x:\blah\blah.ndf,x:\blah\blah_Log.ldf /mountwait=yes
Can a file group be restored from file group bckup..? -ie. primary group from last full backup and requried file grp from latest file group +log bckup
or it has to full bckp every time to restore a single file group ...?
I knw its stupid to ask this but the redbook sg246148 states "You can perform partial restores only on full database backup objects." got confused with this sentence, If its so, then wat is the point in takin file group backups..?
------------
Wat shoud be the command, i m using cli becoz GUI relocate doesnt work for file grop restores (TSM version 5.4.5)
Our requirement is to perform, a single file group backup and restore the same wen required.
Shoud the command be : Tdpsqlc db_name FULL OR it is '"Tdpsqlc db_name Group=filegroup_name
Should I use /groups=.... as well ---Plz send me the command
--------------------------------------------
tdpsqlc rest Database_Name full
/fromsqlserver=Original_sqlserver
/sqlserver=Destined_SQLserver
/partial /groups=TERTIARY
/tsmoptfile=001.opt
/configfile=001.cfg
/tsmnode=node_SQL /tsmpassword=pwd /into=new_db
/relocate=Primary_File-Grp,Required-File-Grp,Log-File-Grp
/to=x:\blah\blah.mdf,x:\blah\blah.ndf,x:\blah\blah_Log.ldf /mountwait=yes
Last edited: