Viewing 15 posts - 9,076 through 9,090 (of 9,244 total)
so your backing up via a maintenance plan are you?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 10:45 am
CrazyMan (7/29/2008)
Windows NT 5.1 (Build 2600: Service Pack 3)
this is your windows OS build version, i am referring to SQL2005 SP2
the SQL product version being reported here
Microsoft SQL Server 2005...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 10:42 am
just a thought, have you applied SQL2005 service pack 2 to the machine
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 10:21 am
SQL King (7/29/2008)
WOW, HOW DO YOU THAT?
eek now i'm getting worried 😀
how are you backing up the databases?
Via a maint plan or a custom job or maunal T-SQL script, etc?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 9:50 am
GSquared (7/29/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 9:48 am
the import wizard inside SSMS uses sql integration services so you have to have that installed.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 9:43 am
The Oracle 10 client should be backward compatible with Oracle 8
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 8:21 am
ensure you scroll to the very top
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 8:13 am
why not just allow the sql maint plan or job to delete files after N days
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 7:39 am
thats what i thought.
when the wizard starts, after the welcome screen the next screen is the choose data source dialog. Drop down the list box "Data source" and "flat file...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 7:37 am
how are you importing?
are you importing via SSMS?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 7:29 am
in SSIS create a new project. Drag a new "Data flow task" from the Control flow items. Edit the new "Data flow task" and in the Toolbox under "Data Flow...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 7:03 am
filegroups offer managability but more over performance. They are primarily designed to be spread across disks\arrays and unless doing so are not going to be of any benefit to be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 6:59 am
i personally wouldnt boot from the SAN, i would have local disks for the OS, stick everything else on the SAN. You have many options available just be sure to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 2:05 am
Hi Andy
this was exactly the same line of thinking i had. Very informative. I think you're right no-one ever changes the default for stats during the create index
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 29, 2008 at 1:58 am
Viewing 15 posts - 9,076 through 9,090 (of 9,244 total)