Viewing 15 posts - 40,996 through 41,010 (of 49,571 total)
swmsan (2/18/2009)
I do backup restore 10 times a day...still I was not able to answer such questions...
Errr, those are pretty trivial questions. If you don't know the answers, how well...
February 19, 2009 at 1:16 am
With 16 GB, you can probably safely increase the max memories to total 14.
February 19, 2009 at 1:08 am
Steve, one query about Active Threads. Some article discussion threads appear in that and some don't. Is that intentional?
February 18, 2009 at 3:39 pm
Best thing would be to have each log on a separate physical drive and, if possible each data file on a separate physical drive
RAID or single disks?
February 18, 2009 at 2:10 pm
Roy Ernest (2/18/2009)
February 18, 2009 at 2:05 pm
Steve Jones - Editor (2/18/2009)
What features would really help you "high posters" here at SSC? Changes to the forums? the site?
Can you ask for one small change please. Remove the...
February 18, 2009 at 2:00 pm
Grant Fritchey (2/18/2009)
Ramesh (2/18/2009)
February 18, 2009 at 1:56 pm
Ramesh (2/18/2009)
Using "sa" LoginUsing Administrator login
Or you can just run the SQLProv.exe tool that's provided with SP2 to set the desired administrative logins for you.
Do a file search to find...
February 18, 2009 at 1:53 pm
Post the execution plan please (saved as a .sqlplan file, zipped and attached)
February 18, 2009 at 1:11 pm
winston Smith (2/18/2009)
Msg 5120, Level 16, State 101, Line 2Unable to open the physical file "C:\DatabaseRestoreTest\Files_location\test_DB_temp.mdf". Operating system error 5: "5(failed to retrieve text for this error. Reason: 15105)".
Google tells...
February 18, 2009 at 1:11 pm
Were there any messages in the error log concerning the restore?
February 18, 2009 at 8:57 am
lior (2/18/2009)
When I run a backup from Management Studio everything go smooth.The error message apears only when the application that is using the database tries to execute a backup.
So what's...
February 18, 2009 at 7:07 am
prakash414 (2/18/2009)
i am getting error after when i am executing this script
I saw that. I'm asking what the sql statement looks like before it's executed. Use PRINT to see the...
February 18, 2009 at 7:03 am
swmsan (2/17/2009)
Can anyone send me some interview questions pls.
Different companies will ask different questions. Memorising sample questions is unlikely to help.
Advice:
Relax
Don't exaggerate your abilities.
If you don't know...
February 18, 2009 at 5:56 am
Are you aware that ALTER DATABASE .. MODIFY FILE does not actually move the files? It just changes the metadata for the database saying where the files are. Once...
February 18, 2009 at 5:22 am
Viewing 15 posts - 40,996 through 41,010 (of 49,571 total)