Viewing 15 posts - 8,821 through 8,835 (of 9,244 total)
if running under a sql agent job as sql agent (i.e. a user other than the user who created the project) this is well known. How does the sql agent...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2008 at 5:35 am
Pam Brisjar (10/19/2008)
They all failed miserably.
quantify this some more! Failed miserably how. I use Redgate SQLBackup commercially over around 10 SQL servers backing up databases, never get a problem!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2008 at 5:31 am
open the job properties and set the owner to sa
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2008 at 2:25 am
using a product such as Redgate SQLBackup you can compress backups by up to 90%
download the free trial and try it out
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2008 at 2:23 am
SQLBOT (10/17/2008)
As someone wrote earlier, the only way to backup a log file is to specifically backup the log file.
to clarify further the only way to truncate log at backup...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2008 at 2:09 am
not sure exactly what you mean but you'd have to ask your administrator which server hosts mail on your network. Test connectivity by Telnet to port 25
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2008 at 1:58 am
or just launch the sql2005 installer and select the sample databases option from the install selection!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2008 at 5:12 pm
SQLBOT (10/17/2008)
ideal if the drive were striped as opposed to mirrored or RAID-5.
RAID 5 employs striping with parity !!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2008 at 5:09 pm
run the traces server side then you'll have no worries 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2008 at 5:04 pm
LOOKUP_BI (10/17/2008)
I need to schedule a sql trace on Profiler.I see a stop time but no start time.Accordin to msdn I can schedule a Trace by the SQL Profiler GUI...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2008 at 5:01 pm
Junior_DBA (10/17/2008)
Guys,please any help???
thanks
i could be wrong and let me know if i'm way off but it sounds to me like you have moved the database to a new server...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 18, 2008 at 4:51 pm
a 2000 character varchar field is certainly going to allow some undesirable isnt it :discuss:
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 16, 2008 at 12:21 pm
think about it and this is painfully obvious 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2008 at 3:20 pm
if using a correlated subquery for checkinga condition\item i prefer EXISTS. I've always been under the impression this should be faster than IN. Am i way off base here?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2008 at 3:18 pm
dp75 (10/8/2008)
To move a database from 2000 to 2005 you CANNOT detach/attach.
this is only true for the system databases. I use detach and restore all the time. When attaching the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 11, 2008 at 4:50 am
Viewing 15 posts - 8,821 through 8,835 (of 9,244 total)