Viewing 15 posts - 31 through 45 (of 215 total)
here is what I have done for years to my SQL 2000 and SQL 2005 databases: full bk nightly; log bk every 15 minutes from 5 am to 9 pm;...
August 13, 2009 at 3:44 pm
if you right click on the db and go to Reports>Disk Usage, how much space used for data and available in Data Files Space Usage?
if you must shrink the mdf...
August 13, 2009 at 3:37 pm
I am not familiar with Dell servers. Probably your IT guys don't go with RAID 10 because the RAID card doesn't support RAID 10?
RAID 0 offers twice the space...
August 13, 2009 at 12:45 pm
here is a vbs file can delete files older than 3 days.
replace the default folder with your folder.
Dim fso, f, f1, fc
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.GetFolder("C:\Program...
August 13, 2009 at 12:24 pm
charipg (8/13/2009)
in server1 , file is C:\folder1i want to copy that file in server2 , file is D:\folder2
pls give the complete command.
dude, you are in wrong forum I believe.
August 13, 2009 at 11:55 am
I found out the cause. SQL databases are backed up to local disk then the whole server is backed up to tape by another server running Veritas backup. ...
August 5, 2009 at 3:06 pm
Interesting info. I will make the change and observe. Thanks.
July 22, 2009 at 12:07 pm
We no longer see this error on the server. I don't remember doing anything to fix it except patching the server with windows update.
April 23, 2009 at 11:43 am
Sorry if it confused you. I said force a failover when there is unexpected problem with the principal server that the mirror server can't see the principal any more....
March 24, 2009 at 4:15 pm
Mohit (3/24/2009)
Also what is your front end application developed in? Even with manual failover your front end has to re-direct connections based on the connection string/cache value setting.
That is...
March 24, 2009 at 3:35 pm
Yes we consulted HP who sold us the volume license and also saw the downgrade phrase on MS web site so we knew it was legit when we downgraded.
There will...
February 25, 2009 at 2:33 pm
used an exisiting SQL 2000 media that we had.
February 25, 2009 at 2:12 pm
the log is empty after I restarted SQL service. Thx.
February 19, 2009 at 2:57 pm
Viewing 15 posts - 31 through 45 (of 215 total)