Activity overview
Latest activity by malikjaved
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...
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...
Backup is not showing all backups in Restore wizard
Hi,
I desperately need of your help for restoring the database, i cann’t Restore database by using Red-gate software, before going ahead i would like to tell you how my backup plan works.
I have ...
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....
Backup Plan
Hi Guys...
i have recently bought a Backup V5.3, i am bit confuse about using it....
it's been said that two job's @ the same time shouldn't be run. so i m totally out of mind :shock: ... i don't ...