Viewing 15 posts - 35,581 through 35,595 (of 39,769 total)
Short answer:http://www.sqlservercentral.com/columnists/sjones/vcspart1.asp
Controlling access is the first thing you have to implement.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 16, 2003 at 3:45 pm
OK, to log in as the sql server agent, you need to check the account under which SQL server Agent runs. This in in the Control Panel | Admin Tools...
December 16, 2003 at 3:43 pm
How do you create the report? Is it some batch job?
Will the server "print" the report automatically? If so, you need to log in as the SQL Server Agent account...
December 16, 2003 at 10:44 am
We're looking at ways to do this. International is a challenge as is the print v web model.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 16, 2003 at 10:43 am
I'd say the core products (all 3) Are about the same. there is higher scalability in Oracle, but I'm not sure the vast majority if people need it. Cost is...
December 16, 2003 at 10:42 am
Depends on how you lay out the SAN. More spindles usually means more performance, but if you carve out a slice of disks for SQL and carve out another slice...
December 16, 2003 at 10:39 am
Tend to agree with above unless you have good reasons (like privacy) for separating the BU data.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 16, 2003 at 10:37 am
You could also move to differential backups, but it sounds like log shipping might be the best solution for you.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 16, 2003 at 10:35 am
I suspect that the "restore" creates a new db first with the log of that size. An interesting problem.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 16, 2003 at 10:34 am
It's somewhat true. A certification shows that you have proven you know something about the product and that you've spent some time learning about it.
Doesn't measure practical experience, nor whether...
December 16, 2003 at 10:30 am
If you change each DB, it should get saved fo the next time.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 16, 2003 at 10:27 am
We run it, exclude the db files as well as the backup folders. No issues. McAfee here.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
December 16, 2003 at 10:24 am
Thanks for the update. A good reason to keep track of everything that happens on a system. No matter how unrelated it seems.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002...
December 16, 2003 at 10:16 am
We use Patrol and it basically is an automated way to get PerfMon statistics. If it exists in Perfmon, Patrol can record and smmarize it.
To get the usage pre db,...
December 16, 2003 at 10:13 am
Interesting. It makes some sense, though I'd hope that people will not make significant changes. Since we are upgrading now, I'll add it to the list.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL...
December 16, 2003 at 10:05 am
Viewing 15 posts - 35,581 through 35,595 (of 39,769 total)