Viewing 15 posts - 766 through 780 (of 2,904 total)
How important is your data?
How much does it change?
If you do full backups once a night (midnight) and your system crashes at noon, can you afford to lose 12 hours...
December 4, 2006 at 4:47 pm
But just to add....
FYI - this poster had this to say in another thread:
im oracle dba and applied for sql dba job and been given sql db questions, to answer...
December 4, 2006 at 4:43 pm
You all are being 'suckered'. This poster is applying for a job that they aren't qualified for and they don't want to do the work themselves.
FYI - this poster had...
December 4, 2006 at 4:42 pm
FYI - this poster had this to say in another thread:
im oracle dba and applied for sql dba job and been given sql db questions, to answer and post it...
December 4, 2006 at 4:39 pm
I had responded to this post. Then I found out in another thread from this poster that they applied for a job, got interview questions, and doesn't have time...
December 4, 2006 at 4:33 pm
Kind of yes. SQL Server doesn't like that since it can't guarantee the network drive will be available when it does the backup. However, I have heard that you...
December 4, 2006 at 12:41 pm
But they ARE corrupted, they won't run in SS2000 anymore. They were built on a SS2000 server, they were moved to a SS2000 server. They were editted with SS2000...
December 1, 2006 at 11:15 am
If you have a lot of large tables, you might want to consider doing the tables individually, or even doing the reindex by individual index.
-SQLBill
November 30, 2006 at 4:02 pm
If the numbers are all integers, try BIGINT.
-SQLBill
November 30, 2006 at 9:12 am
One other thing to check....in Enterprise Manager, where you set the autogrow you can also restrict growth to a specific amount. Do you have that set? If you set...
November 30, 2006 at 9:07 am
F Chen,
Your post has nothing to do with this thread. Please start a new thread with your question.
-SQLBill
November 29, 2006 at 4:12 pm
Okafor,
That's a different question.
Bottom line, you need to license SQL Server for the number of clients accessing the SQL Server instance. BUT, you don't need licenses for the client...
November 29, 2006 at 2:44 pm
We use Symantec/Veritas I3 to monitor our 75+ SQL Servers. It's awesome. It can give you an overview of what's happening and then you can go indepth to see...
November 28, 2006 at 4:03 pm
quote: I think this is because I copied and restored the database manually
If you did that, the database is in a restored state and cannot accept log shipping.
I...
November 28, 2006 at 3:52 pm
Viewing 15 posts - 766 through 780 (of 2,904 total)