Viewing 15 posts - 8,806 through 8,820 (of 9,244 total)
Roger Abram (10/22/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 24, 2008 at 5:40 am
victor_bosc (10/22/2008)
The problem is that the optimization job increases too much the log file,
set the recovery mode to bulk logged before the index rebuild and then back to full...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2008 at 2:39 pm
WMI would be my preference
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2008 at 1:02 pm
check the file and directory exists, if it does exist check the permissions on them 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2008 at 12:50 pm
check for any 3rd party apps, i have seen something similar to this before
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2008 at 12:47 pm
seenu_61281 (10/23/2008)
i know basic import/export thru DTS wizard.
shame that since SQL2005 doesnt use DTS
seenu_61281 (10/23/2008)
What are the other things i should learn?
Get SSIS under your belt and forget DTS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2008 at 12:41 pm
oohhh i dunno, add in a couple of LOB columns and you'd be well away LOL
certainly could do with a little huh hum normalisation 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2008 at 12:38 pm
your welcome m8tey 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2008 at 7:11 am
remember to ensure security permissions are retained on the data folders otherwise the SQL server service may not be able to access the files 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2008 at 7:09 am
use SQLCMD not OSQL, check BOL for SQLCMD help
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2008 at 7:01 am
a little bit of de ja vue with this post me thinks 🙂
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2008 at 1:59 pm
just to re iterate, there is definitely a space after cfg.
copy the line out to a text file and you'll see it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2008 at 1:57 pm
follow the restore gui and in the restore to database type the new database name. select from device and browse for the backup rest is straight forward
or T-SQL
RESTORE DATABASE mine...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2008 at 6:54 am
my this has gone a little OT hasnt it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 21, 2008 at 6:50 am
you are always best to backup to local disk then copy to the network, unless of course you have a guaranteed solid network connection then maybe
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 19, 2008 at 7:05 am
Viewing 15 posts - 8,806 through 8,820 (of 9,244 total)