cfradenburg (12/3/2011)

---

george sibbald (12/3/2011)

---

How can you exempt support staff such as DBAs and network staff when a lot of their work by its nature has to be done outside of...

Unbelievable. How can you exempt support staff such as DBAs and network staff when a lot of their work by its nature has to be done outside of normal working...

same syntax. Partitioned tables are still held within the same database. You may want to look at filegroup backups if the databse is very large, but it all comes under...

does it? Unless you live in the back of beyond should be able to drive 300 miles in 5 to 6 hours 🙂

sorry, that was a section of a larger script, add

declare @as_ObjectName sysname

set @as_ObjectName = NULL

Elliot, sp_help_revlogin maintains sids and passwords

is this what you want?

SELECT replace(state_desc,'_with_grant_option','') + ' '+ permission_name + ' ON ['

+ OBJECT_SCHEMA_NAME(major_id) + '].[' + OBJECT_NAME(major_id) + ']'+

case minor_id

when 0 then ' '

else

' (['+col_name(sys.database_permissions.major_Id,...

If you are restoring a database the users wil be restored with the database

I would use sp_help_revlogin to create the SQL to create the logins on the new server, this...

Copy over your full backup and LATEST differential ONLY. After that you only need to be sure you have all the log backups after the differential available.

so you can then...

well I upgraded my browser to IE9 and the only thing it seems to have broken is the spellchecker in SSC! It puts the amended work back inside the incorrectly...

MyDoggieJessie (12/2/2011)

---

I understand but still seeking clarification on:

If I restore the full backup, then apply the last differentials to the secondary server AND a new full backup occurs on the...

don't blow the logshipping away and start again. Remove all the log backups on the secondary server. On the primary move them to another directory, i.e you just need to...

...took for granted the differential restore would be with norecovery and you haven't previously bought the database online (used with recovery anywhere)

yes you could, but check out log_reuse_wait_desc column in sys.databases first as you have log full errors.

is there the space on the secondary log file drive for the log to increase to the size you increased it to on the primary?

If you do recover the secondary...