Viewing 15 posts - 4,996 through 5,010 (of 9,244 total)
runal_jagtap (9/18/2012)
Thanks Perry 🙂Can you give an example, rough pathfilename etc for this syntax query?
ALTER DATABASE mydb MODIFY FILE(name=logicalname,
FILENAME='new path and drive\the originalfilename.extension')
Yes sure. Let's a ssume i have...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2012 at 2:06 am
This is very easy and in fact I have a request for change for exactly this to complete this week in the organisation where I work. Follow these steps;
get the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 18, 2012 at 1:28 am
jdbrown239 (9/17/2012)
Could I go with repairing just the tables? Either checktable repair_allow_data_loss or checktable repair_rebuild?
Just in case you didnt see my previous answers here it is again
"restore the database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 17, 2012 at 11:57 pm
Restore if I were you at least you have a consistent start point, the data can always be re entered.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 17, 2012 at 11:23 am
SQL* (9/17/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 17, 2012 at 6:35 am
Thanh Ngay Nguyen (9/16/2012)
Of course from sql error log, i got lots of warning about 'IO take more than 15s'.
This is a clear indication that something is wrong. Without knowing...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 17, 2012 at 4:47 am
Windows 2003 or Windows 2008 cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 17, 2012 at 2:40 am
Keep to one post, it'l be easier to track your solutions\answers. Already answered at
http://www.sqlservercentral.com/Forums/Topic1359994-1550-1.aspx
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 17, 2012 at 2:20 am
Have you checked the windows application event log and the sql server log for any possible error messages?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 17, 2012 at 1:20 am
SQL* (9/17/2012)
I am very new to the DBA scenarios, i am learning the things from the Online stuff.
For high availability solution:
1. We need to take the full backup.
2. We need...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 17, 2012 at 1:18 am
ananda.murugesan (9/17/2012)
Principal server mirroring monitor history logs (intervel time every 3 min)
Unsent Log 7588 KB
unrestored log 600 KB
Mirror over head - 40 Milliseconds
Next intervel time those are 0 kb, 0...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 17, 2012 at 1:15 am
If you don't want to write your own scripts, there are many available on Google and on this site. Search a little 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 16, 2012 at 9:52 am
James Stephens (9/15/2012)
I say goodbye to any transactions that have occurred in prod since that 3rd log was taken,
no you dont. You take a tail backup of the primary...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 15, 2012 at 3:24 pm
First check the windows firewall and ensure it is completely disabled, the firewall has 3 profiles. Best thing is to stop the service and set it to manual.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 14, 2012 at 10:24 pm
Can you provide more detailed info on how the virtual environmment is setup?
Can you post details of the odbc connection steps too?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 14, 2012 at 12:39 pm
Viewing 15 posts - 4,996 through 5,010 (of 9,244 total)