Viewing 15 posts - 1,231 through 1,245 (of 1,319 total)
DON'T shrink unless you have a very good reason to do so. This topic has been beaten to death on this site. Do a search and you'll find very compelling...
-- You can't be late until you show up.
April 1, 2008 at 7:35 am
Are you backing up across the LAN (not really recommened) or locally (faster)? Is anything else that is resource intensive running on the SQL server? Backup times are usually fairly...
-- You can't be late until you show up.
April 1, 2008 at 7:07 am
Paul, anything comparable to 'Instant File Initialization' in SQL2K? We're a ways away from SQL2K5 (probably going to SQL2K8) so I'm hoping there is something in our version that I...
-- You can't be late until you show up.
April 1, 2008 at 7:04 am
I personally don't care when it happened, I just want to know it happened. On a weekly basis I run the following. It stores the data for me in a...
-- You can't be late until you show up.
March 31, 2008 at 2:29 pm
I'd drop the indexes before truncating and recreating them AFTER loading the data. It will allow the reload to occur that much quicker because it won't be hitting your indexes.
-- You can't be late until you show up.
March 31, 2008 at 2:19 pm
Sorry, missed that part. We are running SQL2K Enterprise Edition, sp4+. I've seen this article and we actually used it on our Win2K server. But now that were moving to...
-- You can't be late until you show up.
March 28, 2008 at 2:17 pm
It may be quicker to do something like the following:
1) SELECT * INTO T1BackupNew FROM T1 - this'll create a total copy of your table
2) truncate table T1 - faster...
-- You can't be late until you show up.
March 28, 2008 at 7:16 am
That was the part I was stumped on. If I tried this:
SELECT c.DBName,
c.Table_Name,
c.Row_Count ...
-- You can't be late until you show up.
March 27, 2008 at 1:37 pm
Or maybe this??
http://kbalertz.com/237604/Server-Agent-start-displays-error-18456.aspx
-- You can't be late until you show up.
March 27, 2008 at 8:35 am
Does this work for you?
1. open enterprise manager.
2. go under management, right click the sqlserver agent, select properties
3. click on the connection tab (at the top).
4. change the sa password...
-- You can't be late until you show up.
March 27, 2008 at 8:32 am
Check out the last post here and see if it applies. I don't have replication setup here but hopefully this helps.
http://www.dbforums.com/archive/index.php/t-360259.html
-- You can't be late until you show up.
March 27, 2008 at 8:12 am
But, if you search this site, UNC paths for backups are not recommended because a glitch in your network during the backup could corrupt the file. Having said that, at...
-- You can't be late until you show up.
March 27, 2008 at 7:49 am
Not quite spot-on for the topic line but I'd like some opinions on what I should be looked at within profiler. My scenario: I have a server, SQL2K, Win2K and...
-- You can't be late until you show up.
March 27, 2008 at 7:30 am
Would be a great feature but I haven't found one. It's usually an all or nothing process. One common error here occurs when our source file contains more characters than...
-- You can't be late until you show up.
March 26, 2008 at 8:50 am
There are a zillion other threads on this site relating to this very topic (the search feature here works wonders)! Any number of things can cause the log file to...
-- You can't be late until you show up.
March 26, 2008 at 7:55 am
Viewing 15 posts - 1,231 through 1,245 (of 1,319 total)