Viewing 15 posts - 61 through 75 (of 116 total)
What is the operating system you r running on ?
What is the IP of your server?Is it the same as your database IP (Check for virtual IP)
Check the cluster administrator...
November 16, 2009 at 7:14 am
check with the network administrators if there is any upgrade done or any changes done to the routers conf(ACE's etc)
November 2, 2009 at 7:09 am
You can ask them few more questions like:
Is the application runnning slow for all the users or a only set of user(s)?
Is the complete application slow or only a part...
October 1, 2009 at 8:34 am
Do you have a log file redirection which can tell where the exact issue is!
Try splitting the operation into 2 jobs and see if they are working fine as seperate.
September 29, 2009 at 7:14 am
try dbcc indexdefrag(db-name,table-name) instead of DBReindex
once all done do an DBCC UPDATEUSAGE(Db-name)
and exec sp_updatestats.
September 29, 2009 at 7:06 am
You can find information about the latest changes in recovery model in SQL LOGS.
September 29, 2009 at 6:55 am
As per your statements,
You are doing full backup twice daily and diff every 30 min.
Change the full backup to schedule as only once a day, and differential every 4 hrs...
September 28, 2009 at 2:51 am
when do the backups/indexes jobs run, I mean at what time?
They should run only when the user activity is less...see if there is a chance to run them at a...
September 25, 2009 at 2:56 am
If you only want to backup the code of sp's,triggers etc...generate the script of all these objects and save it some version control tool like VSS.
September 25, 2009 at 2:49 am
Thanks for the suggestion, just joined here...looking into things!
Oh..I have lots of questions to ask them...hmm! and test them.
If they do a system restore even my regular trn backups will...
September 25, 2009 at 2:46 am
which edition are you trying to install?
did u meet all the prereuisites...system requirements?
September 24, 2009 at 7:58 am
can you be more clear on your question?
I dont understand in your sense what is prod and what is DR?
September 24, 2009 at 7:45 am
try server_name.database_name..table_name and if works fine...keep an alias(synonym) for this name and go ahead
Pavan
September 24, 2009 at 7:35 am
thanks for the suggestion, havent tested the restore...will surely do that, restored many times with the regular SQL backups, but not from system backup.
September 24, 2009 at 7:30 am
Viewing 15 posts - 61 through 75 (of 116 total)