Forum Replies Created
Viewing 15 posts - 35,821 through 35,835 (of 39,720 total)
-
RE: Full Recovery will take care t-logs?
You still should to run log backups. The log potentially has virtual log files that are not empty and cannot be deleted.
You can use this script to shrink the log
http://www.sqlservercentral.com/scripts/contributions/26.asp
Steve...
-
RE: Resume: New Grad, Orlando(BS in CIS)
Looks pretty goof Mike. Good luck out there.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Restoring To Multiple Files
not that I'm aware of. Unless the backup was from these files. You can always use clustered indexes to move things to multiple files later.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server...
-
RE: Advanced SQL Developer
Where is this?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Test/QC/Production
That is really the best option for doing this. How big is big?
You could use something like RedGate's Compare utilities and "synch" the schemas, not sure about data. They have...
-
RE: Tip: don't forget sp_add_jobserver
Thanks for the info. Wawnt to write this up as an aritle with a little more detail?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Can't see NT Groups
Shouldn't be any different. If you query syslogins, do you both seem the same rows?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: SQL Server Data Changes
Lumigent is really your only option, but if you only need to "read" the log, then there is a lower priced version I beleive.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server...
-
RE: SQL Server 6.5 Maximum Device Size
Yikes, I'd check the BOL for 6.5. I suspect this is in the terabyte range though. I thought I had a 100GB db sometime ago. I know I had a...
-
RE: By author search...
Good idea. Search is one of our week points , but I'll pass along the note to the others. Maybe someone will find a little time.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The...
-
RE: Where Do I Want To Go Today? - From the Field 2
Thanks for the replys. I'll add them to my list.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Fixed width output being truncated
There was an ADO bug that truncated text columns if they were not the last columns in the result set. I don't think that's the case here though.
One other ?,...
-
RE: Identity Column
might need to "reseed" the desitnation table when you are done as well.
dbcc checkident
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: SNORT and MSSQL 2000
We have a general IDS (From NA) that monitors all servers, but not specifically for SQL Server.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Visio and SQL Server naming conventions
Not that I know of. I wish there was as a default.
What I've done in the past is search for new objects each day and get them corrected ASAP.
Steve...
Viewing 15 posts - 35,821 through 35,835 (of 39,720 total)