if you set up a delay then the log will not restore until that delay time has passed

you have 788 MBytes available for processes to use, this is the figure you should be concerned with, rather than free memory.

see http://brandonlive.com/2010/02/21/measuring-memory-usage-in-windows-7/

for one description of what these numbers mean.

please don't go back and amend posts, you have made it look like I have refused to help you for no reason

edited to avoid misrepresentation

this gets server role permissions

set quoted_identifier off

set nocount on

select 'exec sp_addsrvrolemember ' +"'" +loginname +"',"

+"'sysadmin'"

from syslogins where sysadmin = 1

union all

select 'exec sp_addsrvrolemember ' +"'" +loginname +"',"

+"'securityadmin'"...

sanku.raghuram (2/4/2014)

---

how about any other way ,

I can get the destination server to recovery mode.

Can I directly apply the transaction log back up

or Do I need to need get...

do the initial full restore with norecovery, first log restore will put it...

if you mean database permissions they go across with the database, or did you mean server level permissions?

sp_help_revlogin list out logins, their sids, passwords and default databases.

any messages about missing lsns from 'select log_time_utc,message from msdb.dbo.log_shipping_monitor_error_detail' ?

run the last query in previous post and make sure you have all the log backups on your secondary since...

check the growth factor on the file. maybe a small amount of extra data led to a huge growth.

the standard reports in ssms (disk usage) will show when the growth(s)...

probably missing a log backup so nothing for log shipping to apply as far as it is concerned.

run these queries for info

-- error details

select * from msdb.dbo.log_shipping_monitor_error_detail

select log_time_utc,message from...

We have native backup compression now, so why not native backup encryption (no, I don't mean TDE). Are redgate paying microsoft not to do this? 🙂

Why can't SSIS and SSRS...

database permissions are held within the database, so when you copy a database across its permissions come across with it, so there are no server level configurations that can be...

script up the database copy\restore and include the permission change in the script.

ok, now I am wondering why I posted mu upgrade from SQL2000 to 2008 script, must have had a rush of blood to the head!

it is still relevant up to...