Viewing 15 posts - 4,486 through 4,500 (of 4,745 total)
yes to both questions, try and do it at a quieter time ,though adding 1 GB should be pretty quick (depending on hardware)
---------------------------------------------------------------------
April 4, 2008 at 12:51 pm
Dana, if you have more than one file in a filegroup you cannot control which SQL writes to,
SQL writes to multiple files in a round-robin fashion on a percentage fill...
---------------------------------------------------------------------
April 3, 2008 at 3:15 pm
Ed vassies product finebuild contains scripts that will script out DTS packages and jobs for you nice and simply via SQL
http://www.codeplex.com/SQLServerFineBuild
---------------------------------------------------------------------
April 3, 2008 at 2:49 pm
thanks greg, having run the one off query I was thinking of adapting it to output to a table so I could order by most io or whatever.
This will be...
---------------------------------------------------------------------
April 3, 2008 at 10:55 am
Greg Linwood (4/3/2008)
fn_virtualfilestats() is definitely the tool for this job.Here's a script I wrote last year which makes using this TSQL system function easy..
http://blogs.sqlserver.org.au/blogs/greg_linwood/archive/2006/03/15/59.aspx
Greg, you have just made my day....
---------------------------------------------------------------------
April 3, 2008 at 10:35 am
Angela, for the education of others, can you post the eventual fix in this post as well
glad you got there in the end
cheers
george:)
the actual reason for the logon failure turned...
---------------------------------------------------------------------
April 2, 2008 at 3:30 pm
Angela, if you were using ODBC to connect before to 2000, it should still work, presuming the server name was not changed when you rebuilt it.
a number of other reasons...
---------------------------------------------------------------------
April 2, 2008 at 3:10 pm
asizemore (3/31/2008)
---------------------------------------------------------------------
March 31, 2008 at 3:27 pm
asizemore (3/31/2008)
---------------------------------------------------------------------
March 31, 2008 at 2:49 pm
SSMS isSQL Server Management Studio
SO, you lost a SQL 2000 instance and have replaced it with a 2005 instance. You have a backup of your app database but not...
---------------------------------------------------------------------
March 31, 2008 at 2:10 pm
asizemore (3/31/2008)
I'm getting the error:[Microsoft][SQL native client][SQL server]Login failed for user 'LIMSUSA', LIMSPROD
when I try to connect with my front end client.
I can connect through SQL management studio fine.
are you...
---------------------------------------------------------------------
March 31, 2008 at 1:25 pm
create a snapshot of the mirrored database, then you'll have a point in time read only copy you can check.
see database snapshots in BOL
---------------------------------------------------------------------
March 31, 2008 at 1:18 pm
have you got a backup of the old master from 2000? Restore it into the 2005 instance as a database of a different name (ie master_2000) as if...
---------------------------------------------------------------------
March 31, 2008 at 1:03 pm
Shaun McGuile (3/31/2008)
but george - 'database administration is all about deception'-Shaun Tzu's Art of DB Admin. 🙂
LOL 😀
---------------------------------------------------------------------
March 31, 2008 at 7:59 am
Logically everyone should have thought about it and picked the correct answer the 209 level 16 one as that is logically correct,
We do not deserve the points for falling into...
---------------------------------------------------------------------
March 31, 2008 at 7:52 am
Viewing 15 posts - 4,486 through 4,500 (of 4,745 total)