run Chekpoint on database and try take a log backup if log smaller or take full backup then shrink the log file.

Hi Mate,

Restore process:

You want restore a fresh copy or over writing on exists?

if you are creating a new database please check space for new database.

if you are over writing please...

May be this database point to D:\ drive.

1. please look in to data files first.

2. if its point to D:\ change to E:\ drive.

then run the restore script

NO, the script will create 2 store procs on your master db

step1: create proc's on destination server

step2: exec sp_help_revlogin in destination server

save the result set in some where(create login script...

One guy asked me in the interview? I am new to this Question thats why I posted in the forum...

SP_HELP_revlogin will give sql logins script with encripted password and SID. so, you have to run before restore. logins script you have to run after restore.

in this you are getting...

Please go through below link

http://www.mssqltips.com/sqlservertip/1564/database-mirroring-automating-failover-for-multiple-sql-server-databases/

No one knows the answer?

I got the answer

xp_logininfo 'Login_name', 'members'

sql server 2005

Thank you 🙂

Hi,

Check the memory status of the server.

Hi

Database refresh in the sense you have to take the backup of source server database ( Prod or any) and restore with replace on Destination server.

If you are using...

What Kind of error you are facing? can you give us clear picture on it?

It's working Thank you 🙂