Viewing 15 posts - 9,106 through 9,120 (of 9,208 total)
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
gbargsley (7/18/2008)
I am in the process of cleaning up some database records. This is a yearly purge type of process for my software application.
As it sits, my SQL DB...
July 20, 2008 at 1:43 am
You dont mention how big the disks are but i would opt for a RAID1 config on both drives and install everything to the 1 logical drive.
If the drives...
July 20, 2008 at 1:31 am
from memory i'm certain the cluster name is published into AD, search AD for the cluster name and check the container it is in
July 20, 2008 at 1:18 am
On the production servers i have migrated there have always been a substantial amount of windows\sql user logins that have a default database set. Just the way i prefer to...
July 20, 2008 at 1:01 am
you would need to move the databases first otherwise when the script runs to apply the logins it will most likely fail as it wont be able to set the...
July 19, 2008 at 1:48 pm
how big is the log file?
the file will not shrink if there are transactions occupying the file. You would need to truncate the log first to clear transactions then shrink....
July 19, 2008 at 1:43 pm
barb.wendling (7/18/2008)
July 19, 2008 at 1:39 pm
have you checked the sql logs for any errors?
July 19, 2008 at 1:24 pm
what backup product are you using?
July 19, 2008 at 1:23 pm
Viewing 15 posts - 9,106 through 9,120 (of 9,208 total)