Viewing 15 posts - 9,271 through 9,285 (of 9,720 total)
Just an FYI. If you want to append anything, dates, times, characters, to a name (table/column/backup file) in a SQL Script, generally you have to build it in a...
November 26, 2007 at 4:23 am
Or, would you break the mirror and use 4 disks to create a Raid 1+0 and then the other three disks for Raid 5 (for TempDB & the user logs)?
November 20, 2007 at 9:00 am
Break the mirror. Configure one side of the mirror for your Raid 5 (for the user databases). Detach the databases and move a copy of their data files...
November 20, 2007 at 8:59 am
I'm glad it worked.
One thing I would do, if I were you, is to head out to MS's bugs & suggestions forum and see if anyone has reported this as...
November 20, 2007 at 8:40 am
Matt said:
I think Brandie meant how many physical disks are used in the raid 10 configuration. At a minimum it will have 4, so one possible solution would be to...
November 20, 2007 at 8:36 am
When SSIS looks at Excel for the import, it checks the values in the first 5 or 10 rows (I don't remember which). This is the sampling that Tim...
November 20, 2007 at 7:29 am
The simplest solution I can think of is to disable the DDL trigger on the Production DB, backup the production DB with the trigger disabled, re-enable the trigger on your...
November 20, 2007 at 7:00 am
Let's not forget that too many indexes, especially on a small table, will probably cause more performance problems than they resolve.
Best case is to do 1 clustered and maybe 1...
November 20, 2007 at 5:33 am
I'm guessing, but have you tried the sqlncli.msi? If MS is using proper naming conventions, I would read this as SQL Install Client... But I could be wrong.
The readme...
November 20, 2007 at 4:49 am
John,
How are you trying to restore? Via the GUI or via T-SQL?
Also, did you check the sys.files table on the database in question? See what files SQL Server...
November 20, 2007 at 4:41 am
What type of DDL trigger did you create?
Remember, even if you're talking about the trigger being set up on a database scope, if the DDL trigger has anything to do...
November 20, 2007 at 4:39 am
Which direction are you going? Are you creating 2005 as a linked server on 2000? Or vice versa?
I don't think the first one will work. I...
November 20, 2007 at 4:33 am
I've had problems before in 2k5 where using the GUI to attach the DB wasn't working properly and while the database showed as attached, the sys.databases table didn't know it...
November 20, 2007 at 4:31 am
Make sure to notify your end users about the restart of services BEFORE you do it. They may lose data if you don't. (Data not commited to the...
November 20, 2007 at 4:29 am
Viewing 15 posts - 9,271 through 9,285 (of 9,720 total)