you need to have atleast one server in the scale out deployment box, so put the name of the new server back in that box.

as you did a backup and...

LowFatSpread (2/25/2012)

---

Hi There,

For the recovery model. Given that i'm no sql server guru. Recovery

page verify - checksum.

How can I back up everything logs, database from a procedure? Do you have...

best to check what that role can do and then tie it back to people who are db_denydatawriter and db_executors.

in SQL a deny is higher than a grant, but in...

what port are you trying to find out? the port which SQL is running on? you can use the SQL Server Configuration Manager to find that out, if...

you should have some alert jobs for log shipping, these will tell you in your in sync or out of sync as they will either succeed of fail, you could...

this is the offical link for the exam

http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-433&locale=en-us#tab2

take a look at the link in my signature for the string splitter

thanks but that doesnt get free space if the file has unrestricted growth. how do you determine how full the file is to stop SQL auto growing the file...

there is no issue with this I find, dev guys here usually leave SSMS open so as long as they dont execute a statement in a transaction and walk off...

yep thanks got it. cheers again

seems to be a problem with the chars putting in &#x0D

USE [master]; SELECT DatabaseName = DB_NAME(), CollectionD

Sure I can figure it out, time to brush up on my...

Answered my own question I missed this one

SELECT SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

satishm94 (2/24/2012)

---

hi

what if we forget to restore that backup to secondary fro 2 hrs and after that

if i restore thatbckup file means

will other logshipping job backup files will move automatically...

if the job shows as executing in job activty monitor then yes its still running.

to get the box back again with the green play icons etc, I dont think you...

looks like you have a logon trigger enabled, i would suggest looking at that and trying to add the agent account access to login.