Viewing 15 posts - 35,011 through 35,025 (of 49,552 total)
But why would you need a backup? I mean, it's not as if a disk will fail, or someone drops a table (or the entire database) or the data file...
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
January 4, 2010 at 8:43 am
You need brackets around the parameter to the exec.
EXEC @sql -- SQL assumes that @sql contains he name of a stored procedure
EXEC (@sql) -- SQL will execute the contents of...
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
January 4, 2010 at 8:38 am
I don't think there is a comprehensive book, as much of the internal workings, the costing algorithms etc, as far as I know are not public knowledge.
There's a large...
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
January 4, 2010 at 8:28 am
Why on earth is there no backup?
Please run this and post the full and complete output.
DBCC CHECKDB (<Database Name>) WITH NO_INFOMSGS, ALL_ERRORMSGS
Without a database backup, the database cannot be recovered...
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
January 4, 2010 at 8:25 am
If you're happy with rebuilding and losing all your jobs, job history, backup history, etc, then go ahead. If not, I can help you rebuild the log.
Would you mind...
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
January 4, 2010 at 8:21 am
Open in management studio, change the database name (if necessary) and execute.
You are aware that this is just a script of the structure of the DB? There's no data included...
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
January 4, 2010 at 5:30 am
The error log is a text file. Just do a search for it in the OS, it'll be called ERRORLOG.
We can probably do an emergency mode repair and rebuild...
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
January 3, 2010 at 11:49 pm
Developer edition is the full enterprise edition features with a non-production licence, so you lose nothing in the way of features by using it.
If you still have problems, some...
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
January 3, 2010 at 12:01 pm
Renis Cerga. (1/3/2010)
Unfortunately it takes a lot of time, because db is more than 200GB, and DB is in live production, so i can't allow to do it...
You need...
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
January 3, 2010 at 11:06 am
BigSam (1/3/2010)
Does Red Gate have a similar tool for SQL 2k5 & 8? (I've got the Credit Card ready.)
No. From what I heard, they found it not commercially viable, hence...
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
January 3, 2010 at 8:47 am
Enterprise edition is not supported on non-server operating systems. It's only supported when running on Server 2003/2008/2008 R2. Not Windows 7.
Why are you using Enterprise edition? If it's for development,...
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
January 2, 2010 at 10:54 am
Great. CheckDB will take a while, so don't run it when the server is in use.
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
January 2, 2010 at 10:37 am
There are three I know of.
Apex Sql Log Reader
Lumigent Log Explorer
Quest Log Reader
None of them are free. I don't know the price of the quest one, but when I check...
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
January 2, 2010 at 9:54 am
Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.
http://www.sqlservercentral.com/articles/Best+Practices/61537/
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
January 2, 2010 at 9:08 am
Read everything you can find. Try things out until you understand them (not on the production server). Read more. Practice. Read. Repeat for a few years
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
January 2, 2010 at 9:06 am
Viewing 15 posts - 35,011 through 35,025 (of 49,552 total)