Viewing 15 posts - 9,136 through 9,150 (of 9,248 total)
depending on your disk subsystem set up really, extra filegroups are only worth it if they will be placed on separate disks\arrays.
you create the filegroup using the alter database. Add...
July 22, 2008 at 11:36 am
psmith (7/22/2008)
What is the technical reason for leaving the Windows disk as Basic, if you have a raid disk system running your other data files?
dynamic disks are designed to support...
July 22, 2008 at 11:24 am
set the database offline and move the disk file(s) to the new location(s) then run
alter database dbname modify file
(name = logical filename,
filename = driveletter\path\filename.extension)
for each file you move.
Bring the...
July 22, 2008 at 10:40 am
you cant just copy master and msdb, what if the collations are different between servers?
do you have any SSIS packages?
do you have any custom jobs running against the db?
are you...
July 21, 2008 at 3:26 pm
avipenina (7/21/2008)
so i write this syntax and i get an error.why?THX
this should do it
if not exists (select name from sys.configurations where name = 'xp_cmdshell' and value_in_use = 1)
begin
EXEC sp_configure 'show...
July 21, 2008 at 3:05 pm
follow these steps
move the MASTER DB first. Stop the sql instance and agent and copy the database files
(master, model, tempdb, msdb, mssqlsystemresource and dist DB files) to their new...
July 21, 2008 at 12:59 pm
check the NTFS file permissions on the data files
July 21, 2008 at 12:52 pm
G.R.Preethiviraj Kulasingham (7/21/2008)
Do you have SSIS packages stored in the database?What about the scheduled jobs?
Do you have replication in that server?
as above
July 21, 2008 at 12:51 pm
Michelle Potts (7/21/2008)
The new server will...
July 21, 2008 at 9:48 am
Johannsky (7/20/2008)
I am using the default backup tool of SQL Server 2005. I run the backup using job.
having you considered something like Redgate SQLBackup or Quest Litespeed?
July 21, 2008 at 5:16 am
if you have underlying hardware RAID leave the windows disk types as Basic, you do not want or need dynamic disks.
July 21, 2008 at 5:13 am
is the hardware the same on both machines?
you could use symantec GHOST
July 20, 2008 at 2:09 am
why not use one of the built in templates. checl BOL for the template details
July 20, 2008 at 2:08 am
i would check the folder and then the file permissions on the folders the log and data files reside in and the database files themselves, that will undoubtedly be the...
July 20, 2008 at 2:06 am
New Commer (7/3/2008)
i have a query like this,
Select Distinct Table1.name, Table1.Code, Table2.Place, Table2.Marks From Table1 inner join Table2 on Table1.code = Table2.code
which results,
Name1/N1/Nagpur/114
Name1/N1/Nagpur/154
Name1/N1/Nagpur/123
i want it to display as
Name1/N1/Nagpur/114
...
July 20, 2008 at 1:56 am
Viewing 15 posts - 9,136 through 9,150 (of 9,248 total)