Viewing 15 posts - 1 through 15 (of 20 total)
:w00t: whaat... awww.. anyway, thanks for the response! 😀
February 28, 2010 at 8:11 pm
I want to switch from simple to full recovery because of the length of time of restore it takes when restoring full and differential backup everyday. am i on...
February 9, 2010 at 12:08 am
Bru Medishetty (11/19/2009)
isabel-1114008 (11/19/2009)
Is there any way I can RESTRICT my database users access in SQL Server Agent Jobs?Thanks.
Let me rephrase this and understand more of your questions, because just...
November 19, 2009 at 7:41 pm
ps (9/15/2009)
eg explorer c:\ will open the explorer with initial folder set to c:
Its working in command prompt but not with xp_cmdshell.....
September 15, 2009 at 6:57 pm
ps (9/15/2009)
eg explorer c:\ will open the explorer with initial folder set to c:
Its working in command prompt but not with xp_cmdshell.....
September 15, 2009 at 6:55 pm
ps (9/15/2009)
eg explorer c:\ will open the explorer with initial folder set to c:
Its working in command prompt but not with xp_cmdshell.....
September 15, 2009 at 6:53 pm
That is my problem, my users are not sysadmins, but still, they can schedule jobs.
July 16, 2009 at 9:39 pm
Does your command for MIRROR TO DISK supported by MS SQL Server 2000? Because I get the following error when I execute it:
Server: Msg 170, Level 15, State 1, Line...
July 15, 2009 at 2:16 am
then after my restore, do i have to set my database to online mode? or is it automatic?
July 14, 2009 at 1:15 am
what will happen if my "TO" is similar to the original path of my mdf and ldf files? will it cause error that will interrupt my restore? or will it...
July 12, 2009 at 5:43 am
SA (7/9/2009)
You should be able to backup locally and then use xcopy or robocopy in a batch script to move the database backup over to the external device.
I don't have...
July 9, 2009 at 6:13 pm
that makes me crazier about my problem. because our database is in simple recovery model. we do full backups every sunday, and differential backups from mondays to saturdays.
pls help me...
July 8, 2009 at 12:53 am
joeroshan (6/28/2009)
Is your index optimization custom? Does it run for whole DB?Do not shrink your database/ log files. It will lead to fragmentation
No, the index optimization does not run for...
June 29, 2009 at 12:19 am
Viewing 15 posts - 1 through 15 (of 20 total)