Viewing 15 posts - 526 through 540 (of 1,363 total)
I don't see any harm in running on system databases.
MJ
March 20, 2009 at 8:28 pm
Check:-
How to Set the /3GB Startup Switch in Windows
http://technet.microsoft.com/en-us/library/bb124810.aspx
MJ
March 20, 2009 at 7:52 pm
Have you tried running it on active node?
MJ
March 20, 2009 at 7:32 pm
Do you get any rows in output when you run the below mentioned query:
select * from sys.databases
where compatibility_level<>100
MJ
March 20, 2009 at 7:17 pm
Are you running it against sql 2000/2005 server instances?
MJ
March 20, 2009 at 6:15 pm
Do you have any login related information in your central database table so tht script can take the login information from there to add each server as a link server...
March 20, 2009 at 3:48 pm
Check this-->http://www.quest.com/Quest_Product_Demos/LiteSpeedforSQLServer_demo_043007/chap02.htm
MJ
March 20, 2009 at 1:20 pm
Is your sql instance MSSQLServerADhelper service running under local account or domain account? Try an domain account with admin priveleges.
MJ
March 20, 2009 at 11:01 am
Check for index fragmentation and also don't forget to leave enough memory for OS.
MJ
March 20, 2009 at 10:33 am
Try this:
Drop the existing database and then do your restoration
Or
Would be good if you post your restore statement here.
MJ
March 20, 2009 at 9:27 am
To view buffer pool size you are going on the right track
The DMV sys.dm_os_sys_info can be used to view the amount of buffer memory, bpool_commit_target show "target" memory limit for...
March 19, 2009 at 7:26 pm
Do you see integration services and workstation components under "SQL Server 2005 Common Components" category when you click on MIcrosoft SQL Server 2005-->Change-->.... under Add or Remove Programs in Control...
March 19, 2009 at 5:54 pm
Are you able to locate "xprepl.dll" on your server? If not then it seems your sql installation has got sum problem try to repair or reinstall it
MJ
March 18, 2009 at 9:22 pm
Try this:
USE master
GO
/****** Object: StoredProcedure [dbo].[sp_GetSpaceUsedByDBs] Script Date: 03/12/2009 14:41:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create procedure [dbo].[sp_GetSpaceUsedByDBs]
as
create table #ls (name varchar(255), LogSize real, LogSpaceUsed real, Status...
March 18, 2009 at 8:51 pm
Viewing 15 posts - 526 through 540 (of 1,363 total)