Viewing 15 posts - 76 through 90 (of 314 total)
When I last tried this admittedly not on the latest version... all the names were useless, which made it near impossible to find the correct tables. We received a quote...
February 4, 2011 at 7:16 am
A bit strange that it works then does not work.
State 8 refers to a password mismatch, so I wonder if the there is something weird in the encryption if the...
February 4, 2011 at 7:01 am
I dont know much about it, but got sent this link the other day:
http://jasondentler.com/blog/2010/01/exploiting-context_info-for-fun-and-audit
hopefully its of some help to you....
February 4, 2011 at 2:41 am
are you writing multiple files at the same? causing large disk queues?
is anti virus scanning those folders?
February 3, 2011 at 7:56 am
That sounds like the file copy is being blocked/slowed by something on the server...anti virus or something like that.
Do you have access to the server that the backup files...
February 3, 2011 at 2:02 am
As I said, I have not experienced that sort of an issue and been able to directly relate the poor performance to the VLF fragmentation. However, in the past I...
February 3, 2011 at 1:58 am
Is it not worth migrating what can be migrated to the new server and leave the legal app where it is, until it is 64 bit compliant? If it were...
February 2, 2011 at 10:22 am
In the SQL Server error log, do you get an error message with regards to a failed logins?
What SPNs currently exist on the SQL server in question?
February 2, 2011 at 10:16 am
I personally have not seen that.
How many VLF fragments do you have on the DB in question?
February 2, 2011 at 10:13 am
In the past, I have used a combination of IF statements to EXECUTE other procedures with the correct SQL statement (based on usage and search criteria) for specific statements (each...
February 2, 2011 at 10:07 am
Have you considered doing the backup using SQL server compression (since you are running 2008?? This should significantly reduce the size of the file. There are also some points in...
February 2, 2011 at 9:56 am
So the old system was physical and the new system is virtual?
What about the disks where the data, temp and SQL (instance directory) are installed? Have the change config as...
January 27, 2011 at 3:15 am
Koen (da-zero) (1/19/2011)
OK, this was too easy, considered you already asked some questions about VLF's. 🙂
agreed.... might have been a touch challenging before the question about VLFs a week or...
January 20, 2011 at 1:48 am
Would SELECT rights on the INFORMATION_SCHEMA be sufficient?
January 13, 2011 at 3:29 am
Viewing 15 posts - 76 through 90 (of 314 total)