Viewing 15 posts - 166 through 180 (of 346 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...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
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....
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
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)...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
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...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
March 6, 2008 at 3:06 pm
Is there any error text?
Try http://www.eventid.net/search.asp
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
March 5, 2008 at 7:07 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...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
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...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
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.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
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...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
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).
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
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...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
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...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
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...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
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...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
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...
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
March 3, 2008 at 12:45 pm
Viewing 15 posts - 166 through 180 (of 346 total)