Thanks a lot. But per my understanding, this approach will give number as GUID (B85E62C3-DC56-40C0-852A-49F759AC68FB). Is it possible to get a number (Like identity returns) instead?

Many thanks in advance...

Regards

Utsab Chattopadhyay

You may take any one of the below approach:

===================================

Using NT:

1. Make sure the NT login has correct permission on both box

2. Start the copy

SQL Login (Not suggested):

Create a new SQL...

Hey Steve

Looks like u r out of luck here.... We do not have any way to restore a DB if we do not have backups...

That's right. It must be server setting which is reserving this space.

You should not treat it as an issue at all as the log file is <1MB. Plz let...

I also aggreee... shrink command does not build log by itself...

At this point... I will suggest to run a trace to identify what exactly happening with the db... This will...

Nope.. I beleive there is no way to find out what exactly is grabbed and being computed in SQL Server Memory.

So... per me.. best approach will be to limit...

One suggestion... You may try using lightspeed. It will reduce your backup size. Then use robocopy for copying.

Regards

Utsab Chattopadhyay

http://www.consultdba.com

Is it possible for you to follow the below steps:

1. Change the recovery to simple

2. Take a complete backup and then shink db/truncate all the free space from all...

Hi Jeff

Thanks.. Is there any way I could get the expected output?

Many thanks in advance.

Regards

Utsab Chattopadhyay

It's sp_prepare and resides in extended SP of master. Do you have any idea what it needs plz?

Also can you plz tell me if db_datareader grants exec permission on sp...

Nevermind!!! This issue is resolved.

😀

Hi

This issue is resolved after a reboot.. Plz close this thread..

Thanks..

Regards

Utsab Chattopadhyay

I am not sure as I did not try with native backup.. (DB is too big to try and it's in production)

But I executed this job twice and found...

The server looks good and job is runnable only. (Via sp_who2 active)

Do u think killing the sp id will be a good dicission? Then I will drop all indexes and...

On the same issue.. plz let me know if you think if below work around will work?

The DB is bulk logged recovery mode... so delete is logging it. If I...