Viewing 15 posts - 8,431 through 8,445 (of 9,248 total)
wasnt there an issue with maintenance plans not cleaning up?
what version sql server do you have?
to get your version use
select serverproperty('productversion')
February 12, 2009 at 2:33 pm
what security context is the agent running under?
local system, domain account, local user, etc
February 12, 2009 at 2:23 pm
GSquared (2/12/2009)
Definitely don't truncate the log file.
its not too much of a problem because a backup runs immediately after, but still not recommended.
scripts are easier to push out...
February 12, 2009 at 2:19 pm
Jeffrey Williams (2/12/2009)
At a minimum, for a two node cluster hosting SQL Server you are going to have four IP addresses.
six if you count the private NIC ip address too
February 12, 2009 at 2:04 pm
i would drop the statistics in the source (sql2000) database. As Gail said they will be re created if needed (assuming you have auto create statistics enabled on the database).
you...
February 12, 2009 at 1:45 pm
kotlas
have you read the links Steve supplied?
February 12, 2009 at 1:28 pm
scripted backup\maintenance jobs are your best option. Maintenance plans are becoming legacy.
why truncate the log before the backup? What is the recovery model of the database?
February 12, 2009 at 1:19 pm
when rebuilding online simply specify sort_in_tempdb on or off. If a sort is required and you use tempdb just ensure that the location of tempdb has enough space
February 12, 2009 at 1:17 pm
what version of SQL2005 are you using?
default fill factor if not changed is 0 which means 100%
February 12, 2009 at 10:43 am
DROP STATISTICS statisticsname
you can list more than one just separate them with a comma
February 12, 2009 at 10:33 am
alter permissions on the table would be required or one of the built in database roles db_owner or ddl_admin. All of these provide way to many permissions just to truncate...
February 11, 2009 at 3:29 pm
tung (2/11/2009)
Support for AWE is available only in the Enterprise and Developer editions and only applies to 32-bit operating systems.
Again, we are...
February 11, 2009 at 11:20 am
kotlas7 (2/10/2009)
February 11, 2009 at 1:50 am
I use SQL developer even against SQL server databases, it offers me JDBC connectivity to SQL, Oracle, Sybase and even Access.
February 11, 2009 at 1:48 am
create a database role and assign permissions to the role, then assign the users to the role
February 10, 2009 at 5:31 pm
Viewing 15 posts - 8,431 through 8,445 (of 9,248 total)