Viewing 15 posts - 43,576 through 43,590 (of 49,552 total)
As far as I know, all backup logs (including the no_log) have to write into the tran log to indicate that a backup was done. I don't know if it...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2008 at 3:06 pm
sahoong (10/24/2008)
This error message "2008-10-24 00:00:00.29 Backup BACKUP LOG WITH TRUNCATE_ONLY or WITH NO_LOG is deprecated. The simple recovery model should be used to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2008 at 12:06 pm
They didn't have locks on the same key. If you look at the resource, you'll see that while the file and partition are the same, the hash of the key...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2008 at 11:59 am
What is DISA Gold Disk and what is it supposed to do?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2008 at 11:49 am
If you're intending that to be a generic script that can be used anywhere by anyone, you may want to add [ and ] around the index, schema and table...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2008 at 11:47 am
When you generate the script, you can specify what version you want the script to target.
If cost is the concern, consider the 180 day trial of SQL 2005, or...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2008 at 6:17 am
Why was the DB in emergency mode and what exactly did you do to it, from the beginning, step by step.
Can you please also look at the SQL error log...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2008 at 6:05 am
The database size isn't related to performance directly. Increasing amounts of data in poorly indexed tables may be.
The first thing to realise is there there's no silver bullet to fix...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2008 at 5:55 am
Please don't cross post. It just wastes people's time and fragments replies.
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic591095-8-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2008 at 5:49 am
Why were you doing a repair with data loss?
Access violations are usually the result of a bug in the product. To get a resolution for that, you'll have to contact...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2008 at 5:42 am
It would probably be easier if you installed 2005 express at home and used that. To get a 2008 DB to 2005 you'll need to script the schema out and...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2008 at 5:33 am
fjmorales (10/22/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2008 at 4:17 am
Yup, and you should test any recommendations out on a dev system to be sure that they really do help. Also check the recommendations to see if there's an existing...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2008 at 4:12 am
You may want to run a full checkDB on that database to be sure there's no more corruption. From the looks of things, that error can be fixed by dropping...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2008 at 4:04 am
That a a syntax error from the dynamic SQL. Print the SQL before you exec it and you should be able to see exactly what gave the error and what's...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 24, 2008 at 4:02 am
Viewing 15 posts - 43,576 through 43,590 (of 49,552 total)