Viewing 15 posts - 616 through 630 (of 1,583 total)
You can omit this step " copy the temp files back from Z to the disk drive X"
When the SQL services is restarted, the tempdb files are recreated - there...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 26, 2013 at 9:02 pm
Just in case you were curious, all databases were restored successfully without losing any data - it took 14 hours to get them all back and to verify them with...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 26, 2013 at 8:55 pm
If you're just talking about where the actual data files are stored, this shouldn't be an issue. You can change SQL default data file location via the SSMS GUI....
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 26, 2013 at 8:46 pm
Now I think I understand...
I see the datetimestamps are completely different...so it's basically reading it from the last known outcome of the prior CHECKDB that was successful.
I always thought it...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 24, 2013 at 6:32 am
Yes, that's exactly the route that was chosen (even after explaining the consequences, and the possibilities of how much time/unknown data we could lose in the process).
Turns out that didn't...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 24, 2013 at 4:49 am
I reset the status of the database in question and then placed it in emergency mode to run a checkdb with just error-msgs and got back thousands of errors (7MB...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 23, 2013 at 5:40 pm
The databases that are in suspect are on LUNS that came back just fine
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 23, 2013 at 3:59 pm
So there is no other way? We are already restoring the DB that came from the lost lun
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 23, 2013 at 3:58 pm
I'm assuming that the message "Check statement aborted. Database contains deferred transactions." means that SQL is still either rolling forward/rolling back transactions and I just need to wait?
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 23, 2013 at 3:44 pm
My bad, no quotes as the parameter is of type sysname.
Click on the plus sing near the linked server (in the SSMS GUI)
Expand it, click catalogs...
If it throws an error...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 23, 2013 at 2:50 pm
Taken from a post elsewhere:
A new table or index is usually allocated it's first 8 pages from a mixed, rather than uniform extent. So, it's possible for each of the...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 23, 2013 at 2:45 pm
192K, still quite small. The effectiveness of an index seek on a table with so few little rows really won't show much of a performance hit/improvement that a table...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 23, 2013 at 1:35 pm
Don't forget the quotes...
EXEC MASTER.sys.sp_testlinkedserver 'ADSI'
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 23, 2013 at 1:32 pm
I have also seen cases where uses are testing their procedures/queries and leave their session open...depending on the stuff they have been running, it can take up GB's in TempDB...
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 23, 2013 at 11:09 am
See my previous post...
EXEC MASTER.sys.sp_testlinkedserver @server;
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
August 23, 2013 at 11:07 am
Viewing 15 posts - 616 through 630 (of 1,583 total)