Viewing 15 posts - 241 through 255 (of 536 total)
Has the fill factor changed on your index and a rebuild index has been performed??
August 12, 2009 at 8:27 am
As above the statement is just warning you about the size of the snapshots, if you snapshot a 20gb database then everytime you sync the data you are moving 20gb...
August 12, 2009 at 4:57 am
luckysql.kinda (8/12/2009)
can't understand your question. Give some more info..-LK
on reading the question your right. i assumed on first reading it was schema related changes, however this isnt specified by...
August 12, 2009 at 3:30 am
have a look in BOL about DDL triggers (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/edeced03-decd-44c3-8c74-2c02f801d3e7.htm)
You will need to do a database scoped DDL trigger and in it use an if statement to check the object name/id...
August 12, 2009 at 3:28 am
Yes this is normal, part of the recovery process is to restore the latest log with recovery to bring the database online. As noted previously you can setup log...
August 11, 2009 at 3:05 pm
You would generally setup alerts to monitor the jobs and then act upon them when neccesary. Log shipping is not seen as a warm/hot solution, clustering (sql 2000 onwards)...
August 6, 2009 at 3:41 am
its a manual process in which you will need to restore the latest tlog to the secondary with recovery then do something to repoint your applications/users to the new...
August 6, 2009 at 2:01 am
rlondon (7/31/2009)
Jeff Moden (7/30/2009)
Lynn Pettis (7/30/2009)
Is there a more detailed error message in this file: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0014_JMODEN2_MSXML6_1.log?
Yep.... it's quite long so I'll post the only line in...
July 31, 2009 at 10:13 am
mwebster (7/31/2009)
Doh, thanks for letting me know. Since this is in the SQL 2005 section, no help then.Sorry for the misinformation.
sorry i wasnt pointing it out as misleading info,...
July 31, 2009 at 9:22 am
mwebster (7/31/2009)
July 31, 2009 at 9:10 am
sahoong (7/27/2009)
Could someone tell me what code I can use to obtain the latest record that he just been added to a table. I administer a table where newly...
July 30, 2009 at 2:02 pm
There is a product called log me in rescue which is great and is relatively inexpensive. you will only need one license if you are on your own. ...
July 30, 2009 at 1:21 pm
Well you have 2 options
1) Change the password - you wont need to restart anything but any already open connections will continue to work until they need to reconnect....
July 30, 2009 at 1:12 pm
ps (7/29/2009)
charipg (7/29/2009)
what is fillfactor and what are the advantages and disadvantages?
Refer this BOL link to know about fill factor.
http://msdn.microsoft.com/en-us/library/ms177459.aspx
A fill factor of 30 means 30% of space within...
July 29, 2009 at 12:54 pm
what is the job doing?? does it move any files anywhere possibly to a drive that may be full?? i dont think it will be a problem with the...
July 29, 2009 at 11:02 am
Viewing 15 posts - 241 through 255 (of 536 total)