Viewing 15 posts - 43,006 through 43,020 (of 49,571 total)
Try to run a backup from the query window - backup log...
If it doesn't work, what is the error?
November 25, 2008 at 9:14 am
mfaisal (11/25/2008)
Dear......i am found of SQL study. you help me what can i do it?
Please post unrelated questions in a new thread.
November 25, 2008 at 9:13 am
In simple recovery the logs auto-truncate on a regular basis and hence cannot be backed up. There's no point, it wouldn't be possible to use such backups to restore because...
November 23, 2008 at 9:51 am
vkundar (11/23/2008)
Just woundering am I dealing with a BUG ! while trying to restore a very large database (.sls extension) using litespeed restore command Xp_restore_database.
I've backed up and...
November 23, 2008 at 9:49 am
Bear in mind that a san doesn't automatically make things fast. To quote a friend, 'There's no magic san dust'
Even with a san (or especially with a san) you need...
November 23, 2008 at 9:46 am
Amit Gupta (11/20/2008)
You should delete log file 1st then backup and then restorehmmmmm....
No, no, no, no!
The transaction log is not an optional file that can be deleted without causing problems....
November 23, 2008 at 9:43 am
Grant Fritchey (11/23/2008)
Actually, pretty desperate, the deadlock chapter comes up in two weeks! You may see me attempting to answer a few of the deadlock posts as they come up.
If...
November 23, 2008 at 9:36 am
Grant Fritchey (11/23/2008)
Actually, I'm feeling a bit snarky this morning. I'll finish my comments over there.
Likewise, as my reply to the thread Jeff called out shows. I'll blame it on...
November 23, 2008 at 9:31 am
When a checkpoint occurs or when the lazy writer kicks in due to memory pressure. It could be immediately after the change was made, or it could be several minutes...
November 23, 2008 at 12:43 am
No, I can't.
The optimiser's changed so queries the previously ran in one way may run in another way after upgrade. Sometimes that causes errors like conversion. There's no way to...
November 23, 2008 at 12:32 am
Try jumpstart TV. They should have something.
November 22, 2008 at 11:53 pm
Why? What purpose are you trying to get that information for?
If you don't need it exact, query sys.dm_db_index_physical_stats for that table, use the detailed option, check the avg_record_size_in_bytes column and...
November 22, 2008 at 11:47 pm
You should not be using the profiler gui to monitor a busy production server. Especially not very frequent events like the lock aquired. At best you'll kill your machine, at...
November 22, 2008 at 11:37 pm
Jeff Moden (11/22/2008)
Is that true, Gail? Is there a book out there with your good name in it as a co-author?
Co-author, no. I've contributed to a book project, that's...
November 22, 2008 at 11:22 pm
Queries that work on 2000 but throw errors on 2005, either due to syntax that's now invalid or changes to the optimiser is the main one I've seen.
Another fun one...
November 22, 2008 at 11:21 pm
Viewing 15 posts - 43,006 through 43,020 (of 49,571 total)