Viewing 15 posts - 9,151 through 9,165 (of 9,241 total)
have you checked the sql logs for any errors?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2008 at 1:24 pm
what backup product are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 19, 2008 at 1:23 pm
LISETH_T (7/15/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 4:13 pm
go into add\remove programs and find SQL server 2005 then click remove.
the wizard will start and ask which instance you want to remove. select the radio button for the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 4:09 pm
even if you dropped the PK and loaded the data as soon as you try and re create the PK it would fail anyway
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 3:04 pm
why not alter the column and add the NOT NULL clause.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 2:52 pm
ALZDBA (7/17/2008)
but that will generate log-file overhead.
set the database to bulk logged recovery mode before executing the delete statements
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 2:45 pm
for a filegroup to be of any use it would need to be spread across a separate array to the primary filegroup. Cant see any advantage to creating filegroups and...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 11:06 am
jsgault (7/14/2008)
Thanks for your help everyone. It is working now, hooray!!
well done!!
jsgault (7/14/2008)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 10:54 am
srbrewster (7/17/2008)
I need the query to determine the mdf file location of a database.
just change fileid to 1 instead of 2 as below
select a.name, b.name as 'Logical filename', b.filename from...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 10:49 am
if you have the original SP2 file sitting around on the network remove it and replace it with the latest so it doesnt get re deployed in future 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 10:47 am
what disk set up (RAID arrays, etc) are you using on your SQL server
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 10:44 am
you don't need to detach the database
set the database offline using
ALTER DATABASE mydatabase SET OFFLINE
you can then do what you like with the disk files (even delete them). Move the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 10:38 am
what state do you require the replicated database to be in?
standby or full access
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 6:20 am
rinu philip (7/16/2008)
Now if the target size is not reached with the above command, we can go on to truncate the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 17, 2008 at 3:21 am
Viewing 15 posts - 9,151 through 9,165 (of 9,241 total)