Viewing 15 posts - 91 through 105 (of 158 total)
Adi,
The logins program name is 'xxxxx database application' and it has several different host names ie room1, room4, room6. I am not familiar with the application so how would I...
May 12, 2011 at 7:03 am
I read that I should consider putting the database into single user mode before performing the maintenance on it. So now I am wondering since the users is just an...
May 12, 2011 at 6:59 am
You are correct! Thank you! I have since patched each node of the cluster up to sp4 individually by pausing the inactive node at the time through clus admin.
Thanks again!
May 10, 2011 at 11:06 am
This article was very helpful however I have one question I was hoping someone could answer...
The article states that one must "modify each of these configuration files to point...
May 9, 2011 at 1:28 pm
Ok thanks John!
64 bit has been installed!
April 28, 2011 at 8:56 am
Will I have any issues accessing it through SSMS on my desktop? The SSMS i have is 32bit. Also, will I be able to edit maintenance packages,etc?
April 28, 2011 at 6:58 am
Ok this seems to be a two step proccess. Users + Logins. Thanks for the info.
April 14, 2011 at 5:47 am
John Mitchell-245523 (4/4/2011)
April 4, 2011 at 11:17 am
I'm SA.
April 4, 2011 at 8:06 am
Ninja's_RGR'us (4/4/2011)
Are you logged in the correct instance?Are you logging as a SA? If not, do you have permissions to access that db?
Good point..checking on that now..
April 4, 2011 at 8:05 am
GilaMonster (3/31/2011)
Vertigo44 (3/31/2011)
Ughh. Yeah I think I'm going to read up on taking away delete rights next! 😀
If this is a production server, why the hell do they have any...
March 31, 2011 at 9:11 am
GilaMonster (3/31/2011)
From the forum you posted in I assumed 2005.
You can restore the logs with standby and inch the STOP AT time forward bit by bit. Tedious, but that's...
March 31, 2011 at 8:23 am
Thanks Gila!
I am not seeing the missing transactions. Let's say the developer doesn't actually remember what day/time he issued the delete statement. Is there a way in SQL 7 that...
March 31, 2011 at 6:10 am
I have Full backups from:
3/14:2300 | 3/15:2300 and on
And Logs from:
3/15:0000 | 3/15:0400 | 3/15:0800 |3/15:1200 |3/15:1600 |3/15:2000
The developer deleted that data on Tuesday 3/15 around Noon I believe.
Being the...
March 30, 2011 at 9:19 am
GilaMonster (3/21/2011)
Vertigo44 (3/21/2011)
Does SQL server delete them from the file system knowing the database was recovered without them therefore it thinks they aren't needed?
Absolutely not. Database restored in no way...
March 22, 2011 at 4:49 am
Viewing 15 posts - 91 through 105 (of 158 total)