Viewing 15 posts - 496 through 510 (of 859 total)
gpitkis (2/23/2011)
Hello to All,I have to backup a db( 3GB in mdf file, 200GB in ldf file, no free space) to remote location.
Any suggestions?
Thanks in advance for your help
3GB in...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 28, 2011 at 12:04 am
Thanks Lowell its sysaltfiles.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 27, 2011 at 11:52 pm
bsouji2006 (2/25/2011)
Hi everyone,i need to attach databases automatically by cursor loop. my databases are like ac_001 till ac_294.
if anyone has idea can you please share with me.
thankyou
Try to write a...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 25, 2011 at 4:04 am
bsouji2006 (2/25/2011)
can anyone please help me
i have configured database mail, we dont have Mail server(smtp), so i have used gmail. am getting following error
The mail could not be sent...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 25, 2011 at 4:02 am
shifty1981 (2/17/2011)
sean.massey (2/16/2011)
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 18, 2011 at 3:59 am
You have some problem with your smtp server.
1.check the account & password
2.Check the mail server smpt & fire wall too
3.Restart the server and try again
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 17, 2011 at 1:10 am
I think you just copied from your email 🙂
The reason is the index is not fulfill the where condition.
select ParentEmployeeKey,SalesTerritoryKey,title from DimEmployee where ParentEmployeeKey = 3 and SalesTerritoryKey = 11
You...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 16, 2011 at 1:39 am
Did you see the M.Plan history error?
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 15, 2011 at 11:39 pm
kp_kumar (2/15/2011)
i can see low PagelifeExpectancy and high pages/sec showing memory issue..
Start a new thread to ask the questions.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 15, 2011 at 11:07 pm
iczerz,
Can you show me the errors.
See the gamil account setup. this may be help to you.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 15, 2011 at 10:59 pm
sean.massey (2/15/2011)
I don't know if there is enough information provided here to give you a definite answer. Is 150MB too low? Well it kind of depends. Are you seeing paging...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 15, 2011 at 7:07 am
janet.gillespie (2/14/2011)
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 15, 2011 at 1:19 am
shifty1981 (2/14/2011)
Thanks, but I need some sort of article or technical explanation of why it's important to have roughly 20% of memory available.
shifty1981
Check the counters,what i have given? You...
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 15, 2011 at 1:11 am
Yep,You should have that permission.Ask you Manager Or N/W to grant the required privilege.
If you don't have any choice then go for "cmdshell" (security risk).
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 14, 2011 at 12:46 am
shifty1981 (2/13/2011)
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
February 14, 2011 at 12:21 am
Viewing 15 posts - 496 through 510 (of 859 total)