Viewing 15 posts - 4,996 through 5,010 (of 9,253 total)
Sudhakar Vallamsetty (9/18/2012)
September 18, 2012 at 5:21 am
Satish-1028188 (9/18/2012)
I have logshipping configured in SQL Server 2008 boxes, some times this goes out of sync for some of databases (few of them are quite large in size) due...
September 18, 2012 at 4:44 am
great, just make sure to pay attention to what you're doing and it will be fine
September 18, 2012 at 4:20 am
runal_jagtap (9/18/2012)
What are the steps for setting the tempdb datafile & log files to other locations???
The same as i detailed above 😉
You just need to restart the SQL Server service...
September 18, 2012 at 3:28 am
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...
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...
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...
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.
September 17, 2012 at 11:23 am
SQL* (9/17/2012)
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...
September 17, 2012 at 4:47 am
Windows 2003 or Windows 2008 cluster?
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
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?
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...
September 17, 2012 at 1:18 am
Viewing 15 posts - 4,996 through 5,010 (of 9,253 total)