Viewing 15 posts - 46 through 60 (of 131 total)
I can log in on the server itself via Windows authentication, no problem. Restored databases and everything. Server is up and running. Just can't connect from another PC. I AM...
February 9, 2012 at 8:44 am
- Mixed mode
- Trying to log in with a different account than I installed with. Logging in with my network account, which is defined as sysadmin in sql server.
- Not...
February 9, 2012 at 8:31 am
With a transaction log that large, I would agree that something, somewhere is using model db.
But also keep in mind that the transaction log for model will grow if it...
December 22, 2011 at 9:12 am
Steve - Probably not anytime soon. Our support agreement with Quest is up and, although I'm in the process of renewing it, I don't know how long that will take....
December 7, 2011 at 8:52 am
I did one more test. I took the native SQL backup I had made (that did NOT show the extra logical file), restored it, then took a LiteSpeed backup. The...
December 7, 2011 at 8:46 am
Here's a follow up. Last night, I made two native SQL full backups of the database on the 2008 R2 system back to back, followed by one LiteSpeed full backup....
December 7, 2011 at 8:18 am
I just went through all of this two days ago setting up a new 64 bit server. I think what fanzhouqi is referring to is that when the SQL Server...
December 7, 2011 at 8:12 am
Robert - that's good to hear. But we've taken 4 full backups so far and the issue persists. Now these were all backups made with LiteSpeed. I'll try a native...
December 6, 2011 at 10:00 am
It does not show up in sys.master_files.
December 6, 2011 at 9:42 am
Regardless of the length of my commute, I always try to live east of my office. That way, I'm never driving into the rising or setting sun during the commute.
August 19, 2011 at 9:02 am
Just to document.. I found the solution. I performed both steps listed in the second solution at http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/ee918522-2190-4d5e-9e25-a8ae34ced025/
Turns out the SQL Server service account was not a member...
August 12, 2011 at 8:22 am
This is Windows server 2008. Checked both the app and system logs.
August 11, 2011 at 5:39 pm
EdVassie (7/5/2011)
The most common is if you move a system database and use...
July 5, 2011 at 10:46 am
Yeah, DBCC CHECKDB comes back clean for all system databases.
June 30, 2011 at 9:30 am
Viewing 15 posts - 46 through 60 (of 131 total)