Viewing 15 posts - 166 through 180 (of 345 total)
Existence of path. Available disk space. Initial size, growth rate/type. Number of files. Use of filegroups.
Security (both for creating the database and who can access it...
March 6, 2008 at 7:37 pm
Is it sustained or bursts?
It will be high because something is doing a lot of reads and/or writes. There are perfmon counters for each, check them for a start....
March 6, 2008 at 7:24 pm
What does it say in the SQL Server ERRORLOG and the SQL Agent Log?
By default they are in ...\MSSQL.1\MSSQL\LOG (initial bit depends on drive, folder where you installed SQL Server)...
March 6, 2008 at 3:30 pm
You can't edit it. Drop & add are your options. That field is there for when you setup a new one. You can't use it to edit...
March 6, 2008 at 3:06 pm
You can try running profiler on the SQL Server to see that the app is actually logging in correctly (if at all). And to see how the queries it...
March 5, 2008 at 4:17 pm
Jack Corbett (3/5/2008)
I don't need to intimidate my code, I always do it the best way the first time;)
Oooo, them's fightin' words! You're asking for trouble making statements like...
March 5, 2008 at 4:12 pm
That's because the properties of the DB in SSMS show the last FULL backup. I don't think that can be changed.
March 5, 2008 at 4:05 pm
I've restored the system dbs from one SQL 2005 server to another (don't ask me why, I can't remember. Pretty sure it was more than just to see if...
March 5, 2008 at 3:59 pm
No problem. Although it would be best to use a dedicated service account, no password expiry (set a really long, complex password).
March 4, 2008 at 4:01 pm
Any firewalls between you & the server? If there is more than one instance on the server, subsequent instances will be listening on different TCP ports (dynamic by default...
March 3, 2008 at 6:37 pm
So when was it last running? Any ideas as to why it stopped running? Hint: what changed?
Presumably SQL Server is running. Can you connect to any...
March 3, 2008 at 6:29 pm
So what account is the SQL Server service running with? And does that account have any rights to the network folder (hint - if it is running as Local...
March 3, 2008 at 6:19 pm
How much of that 5GB disk space is actually data vs empty space?
Run sp_spaceused in the distribution database.
You may be able to reclaim some space back without changing...
March 3, 2008 at 12:57 pm
You can connect to your SQL server and issue the following T-SQL command:
exec sp_dbcmptlevel mydb, 80
go
Make sure you have no other connections open at the time (Books Online actually recommends...
March 3, 2008 at 12:45 pm
Viewing 15 posts - 166 through 180 (of 345 total)