hi,

I developed a test case for restore scenario. Plz advice me like the scenario here what are the other possible scenarios we can build.

Scenario : How to recover the data...

Ok..

What happens in below scenarios:

1.If mdf file exist and ldf file deleted can we do the point in time recovery?

2.If ldf file exist and mdf file deleted can we do...

Thank you..

I got it by using stop at = datetime.

But when whole database is deleted, we can not take the tail backup right?

So in that case we can not...

Thank you..

Here is the script

Backup tail log:

BACKUP LOG [abc]

TO DISK = N'F:\BACKUPS\abc_Log\abc_Log.trn'

WITH NO_TRUNCATE , NOFORMAT, NOINIT, NAME = N'abc-Transaction Log Backup',

SKIP, NOREWIND, NOUNLOAD,...

I did not mentioned here...

Here is the backup job 'Backup BizTalk Server (BizTalkMgmtDb)' which requires sysadmin role as per the biztalk security document. can we restict the user not...

can any body plz advice me some scenarios to test....

In Oracle we have test cases like

if datafile is deleted go for this method to restore

if database corrupted go for...

Hi,

can we move resource database mdf to one drive and ldf to other drive(resource database mdf to master database mdf location n resource database ldf to master database's ldf location)

or...

Yes,the bts admin has the Security admin role and ddladmin and dbaccess database roles on the particular databases that the jobs are using.But for one particular backup job,it needs sysadmin...

Hi All,

Iam trying to test different restore scenarios

from my backups and document them, inorder to recover the data in disaster situations.

So for this purpose I created a script which inserts...

Thanks..

Generally Who are the members of the NT AUTHORITY\SYSTEM and BUILTIN\Administrators

what actualy these logins do? In what circumstances we use these logins?

In my case....there is only one backup job(created...

can have some script that works for method2....

Thank you

Iam testing the restore scenarios to get the data upto point in time. So for that I need to generate the log in one database by inserting data...

Could you plz explain me why this approach is better?

any performance gain?

That means not to store the Report server n reportservertempdb database on 4th server(RS server)?

then why we need the 2 database engines installation on 4th server?

or do we need to...

thanks a lot Schadenfreude,

Could you plz me provide me document that supports, the way we are approaching is a best practice. Because I suggested the one you explained me, ...