Viewing 15 posts - 631 through 645 (of 1,319 total)
Personally, I never backup the data folder. Unless you shutdown the SQL server, the files are in use. As stated by David, there are some applications that allow you to...
-- You can't be late until you show up.
May 22, 2009 at 8:54 am
Personally, I wouldn't setup any relationships between the data (FK constraints) as this could affect the data load and it's simply a reporting database. Besides, those types of relationships are...
-- You can't be late until you show up.
May 22, 2009 at 8:28 am
You can use sp_who or sp_who2 to determine the thread and then issue kill spid. I'd be hesitant because if the thread does have an open transaction, the data will...
-- You can't be late until you show up.
May 21, 2009 at 6:21 am
Roy Ernest (5/20/2009)
Got two kids... 😛
Face it Roy, you're already insane but are too insane to realize it! 😀
-- You can't be late until you show up.
May 20, 2009 at 2:44 pm
If you can log into the physical server, open task manager to gauge what is consuming the resources. If it's SQL and you cannot get in, check the server event...
-- You can't be late until you show up.
May 20, 2009 at 1:11 pm
Roy Ernest (5/20/2009)
-- You can't be late until you show up.
May 20, 2009 at 10:26 am
Lynn Pettis (5/20/2009)
Tom Brown (5/20/2009)
Lynn Pettis (5/20/2009)
Roy Ernest (5/20/2009)
-- You can't be late until you show up.
May 20, 2009 at 10:00 am
Alvin Ramard (5/20/2009)
tosscrosby (5/20/2009)
Lynn Pettis (5/20/2009)
-- You can't be late until you show up.
May 20, 2009 at 9:52 am
Lynn Pettis (5/20/2009)
You know what? I think some of us (me included) really need a vacation in some far off exotic locale. Too bad I can't afford one...
We...
-- You can't be late until you show up.
May 20, 2009 at 9:35 am
Lynn Pettis (5/20/2009)
Roy Ernest (5/20/2009)
Is the Window washer player around in T-SQL section? I just want to take a peek... 😀If you really must, he's here.
Holy smokes! Some people are...
-- You can't be late until you show up.
May 20, 2009 at 9:09 am
Not sure about the third-party tools but thought I'd chime in. I use the native-OS defragmenter. Usually about once a year, maybe a little longer than that, on the entire...
-- You can't be late until you show up.
May 20, 2009 at 8:56 am
This is what I do. It all depends on the amount of data loss that your users can endure - all depends on them and your application.
1) Full backup of...
-- You can't be late until you show up.
May 20, 2009 at 7:57 am
achleshsoni (5/20/2009)
2009-05-20 01:22:20.300,Logon,Login failed for user 'sa' because the account is currently locked out. The system administrator...
-- You can't be late until you show up.
May 20, 2009 at 7:44 am
ip2host (5/20/2009)
I didnt correctly express myself.I truncated trans logs after full backup each base and trans log.
I had to coz it reached 30gb.
After you truncate the log, you MUST do...
-- You can't be late until you show up.
May 20, 2009 at 7:31 am
If this is coming via an application, never use sa. Unless your code is somehow encrypted, your sa password is then floating around embedded in code and easily obtained by...
-- You can't be late until you show up.
May 20, 2009 at 7:12 am
Viewing 15 posts - 631 through 645 (of 1,319 total)