Viewing 15 posts - 8,806 through 8,820 (of 9,241 total)
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
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
Viewing 15 posts - 8,806 through 8,820 (of 9,241 total)