Viewing 15 posts - 1,711 through 1,725 (of 2,496 total)
The standard industry practice to prevent people hacking into your data file is encryption.
SQL Server supports encryption of its databases. If the DBA does not know the encryption key,...
March 20, 2008 at 6:25 am
Just a guess, but have you checked that the SMTP server still has the same address, is still working, and there is still a route through your local firewalls from...
March 19, 2008 at 4:01 am
If you want some scripts that will do these moves, try SQLServerFineBuild.
March 19, 2008 at 3:53 am
It may be safe to remove the log files, but this will be just a very temporary solution. The next time fixes are appiled to Windows, the install process...
March 19, 2008 at 3:49 am
I completely agree on the need to test the restore process by starting with getting the tape (or whatever) from offsite storage.
This tests a lot of thing you need in...
March 19, 2008 at 3:38 am
Once you have confirmed the new install location and that your system databases are referencing it then you can manually remove the c:\program files\microsoft\sql server
Don't do this unless you...
March 19, 2008 at 3:22 am
I agree that getting a vendor product to do the scripting is likely to be the most comprehensive answer.
However if you want something free, take a look at SQLServerFineBuild. ...
March 18, 2008 at 3:58 am
I certainly reccommend running CHECKDB, but I think it should be run at the most convenient time of the day which may not be when you do a backup.
At my...
March 18, 2008 at 3:50 am
If you have multiple instances on a box, they will all compete for the available memory. None of the instances are aware of what the others are doing, so...
March 18, 2008 at 3:39 am
You may need to change the service account logins. See BOL on how to do this.
March 17, 2008 at 4:35 am
You cannot change the permissions on any system object in SQL Server 2005 & 2008. This is because the permissions are held in the mssqlsystemresource db, which you cannot...
March 17, 2008 at 4:31 am
If you are looking for scripts to smooth the SQL Server 2005 install process, try http://www.codeplex.com/SQLServerFineBuild. This gives you a single-click best practice install and configuration for SQL.
March 17, 2008 at 4:24 am
My take is that if the Windows admins want it moved for existing installs, they need to show the costs, downtime, risks and benefits involved in the move. If...
March 14, 2008 at 5:43 am
A lot of Windows Administrators like to keep the system drive reserved for the OS as far as possible. If this is happening at your place it is a...
March 14, 2008 at 3:27 am
I had issues in my old place in SQL Server 2000 in jobs that are run automatically when Agent starts. The best I can remember is sometime a auto...
March 12, 2008 at 3:47 am
Viewing 15 posts - 1,711 through 1,725 (of 2,496 total)