No idea it has almost 5,000 rows of text file

Hi,

Shall we do it with error handling? Can you give me some sample to do like that in this situation

Yes, I did but still it is showing that primary key violation.

Here the table has only two columns but both two columns are the primary key.

I use the statement

Merge table1...

Thank you

If the Tail log backup is not necessary on the target before a restore, what could be the reason to get that error message?

After the tail log backup only...

What is that replace option. I just use the

restore log Test1 to disk = 'd:\dbdumps\Test.bak'

It looks restore is working now. So is it mandatory to take the tail log...

But it is showing that the tail of the log for the database Test1 has not been backed up yet

Restoring the database terminating abnormally

I use the command

alter database Test1

set single_user

with rollback immediate;

go

Restore database Test1

from disk ='\\Test\DBdumps\test1.bak

with recovery

in the same spid

but I am getting error restore can't process the database Test1 because this...

Also I am little confuse about the keeping the database in single usermode.

If we did from the GUI to keep the database in single user mode and another window might...

I gave extra .. Now it is working fine.

Thanks

But one question regarding the logins when we are restoring the database from the prod to production support still we need to...

I don't have enough space to copy the backup file locally to restore the database.

I need to restore from the network path only.

When I gave the network path in ssms...

Before restoring the database do we need to kill the existing connections?

Do we need to set the database property option set to restricteduser

Yes. Got it

Thank you

Correct me my understand is wrong

so compare to the copy the backup into the local and restore, it is better to restore from network

Hi,

How to check existence of symmetric key on the another server to restore the TDE deatabase backup