Comments
Sort by recent activity
I am really sorry i couldn't Get that..
what i want to do is to resotre database from the Second last Transactional Backup..
So you mean i have to put all Transacial and Differential and full backup files into a same folder and then manuall add each file by using this code. and then execute them all in once..
in my case every time when transaction backup run it's create a seprate log backup file for each backup. So that's y i am confuse, how do i add each file name in the code, or i have to write same code for each log file seprate..
Code:
EXEC master..sqlbackup '-sql "RESTORE DATABASE AdventureWorks FROM DISK = [g:\backups\logs\AdventureWorks_LOG*.sqb] WITH NORECOVERY"'
the Full backup was taken @ friday after noon, and then laster on remain day Transactional backup runs after every 30 mint, then in the night time a differential backup along with truncate transcation backup taken and then again upto the time of restore a log files backup taken... / comments
I am really sorry i couldn't Get that..
what i want to do is to resotre database from the Second last Transactional Backup..
So you mean i have to put all Transacial and Differential and full backu...
Thanks petey.. it's really help me alot for solving the problem as well as understanding how backup work's ...
any way i need you brain more for 5mint's ....
could you please tell me how can i make DISASTER RECOVERY PLAN...
i am quite good doing with sql native backup jobs. but i am not good in red-gate..
what i use to do in navtive sql .. full backup weekly , differential backup along with truncate transactional backup every day, and transactional backup after every 30 mint..
but now with red-get. it's create a single for each backup.. all file's are seprate and that's make b bit confuse.
do you have any good plan and how often old backup files i should remove.... / comments
Thanks petey.. it's really help me alot for solving the problem as well as understanding how backup work's ...
any way i need you brain more for 5mint's ....
could you please tell me how can i make...
Thanks for your reply..
Can you recommand me a full Desistar Recover plan for any database.. How should i have to schedule my database backups...i mean transactional, differential and full backups.... / comments
Thanks for your reply..
Can you recommand me a full Desistar Recover plan for any database.. How should i have to schedule my database backups...i mean transactional, differential and full backups....