Viewing 15 posts - 256 through 270 (of 306 total)
Under database options check to see if the truncate log on check point isn't set.
Do you any nonlogged updates? A DTS package moving a table or rebuilding a table?
John...
January 15, 2003 at 1:26 pm
A full backup restored to the standby server is not needed unless there was some failure there. Just keep appling the next transaction log. Why not increase the frequency...
January 13, 2003 at 1:47 pm
I disagree, If your looking for a dsiaster recovery model, then Log Shipping is is no brainer. Replication is an additional overhead on the Production server.
see discussion:
John...
January 13, 2003 at 1:15 pm
msdb..Sysjobhistory will tell you when a job completed.
You can see the job running by
select program_name from master..sysprocesses.
look in the results for something like...
January 13, 2003 at 12:31 pm
Where is the job?
John Zacharkan
January 13, 2003 at 8:44 am
Steves' absolutely right, not sure where my head was before.
I like Raid 1 on my logs and backups. But I only recommend this if it's Hardware implemented. Don't...
January 10, 2003 at 11:59 am
If possible, suggest bouncing the server. I had the same bizzare situation yesterday. Agent is running but it's not, the only thing that cured it was a good bouncing....
January 10, 2003 at 10:09 am
What's the size of your log after the 5:30AM and 9:00AM loads, but before the backup hits? That should answer your question on how much space you need.
...
January 10, 2003 at 9:22 am
You really need to analyze and define your needs. If you have any thoughts of using the failover server for just that failover, then I would not consider it as...
January 10, 2003 at 8:51 am
ALTER DATABASE MODIFY FILE (NAME = logical_file_name, NEWNAME = new_logical_name...). is a SQL 2K thing, not sure of how to do that in 7
John Zacharkan
January 8, 2003 at 8:37 am
If you can use BCP that would be an excellent choice.
If you need to do allot of data manipulation then control the data load through transactions. Sounds like your...
January 8, 2003 at 8:13 am
Many good ideas, depending on the one you take be mindful to check for any triggers.
And just the same I'd still take a backup, even if I have a...
January 7, 2003 at 2:03 pm
Agree as well.
Case #1 is very clear as to what is running and when, no need to read documentation or figure out anything. Remeber KISS!
John Zacharkan
January 7, 2003 at 1:19 pm
God I miss Cobol, try going from DMSII(hiearcle database) to EBCDIC flat file to tape to Ascii to SQL Server.!!!
Try this site http://www.rosetta-stone.co.uk They're the best...
January 7, 2003 at 12:22 pm
Not being smart or anything but to answer your question:
select hostname from master.dbo.sysprocesses
Why is it stored in sysprocesses that way - That's a difficult question - Are you familiar with...
January 7, 2003 at 10:44 am
Viewing 15 posts - 256 through 270 (of 306 total)