Viewing 15 posts - 16 through 30 (of 149 total)
Post your connection string. Just change the server name, IP address, db name and credentials.
From the PC you are trying to connect with, can you connect using a UDL or...
August 24, 2011 at 9:48 am
Try changing your connection string to use SQLNCLI (SQL Native Client).
Post your connection string.
Also check to see what the users default DB is. Some people set a default DB...
August 24, 2011 at 9:34 am
GilaMonster (7/21/2011)
Let's consider this situation....
Now your situation
And that's the gamble.
In the pleasant scenario you give there's a chance (it happened more than once) that the one, or many, TX log...
July 21, 2011 at 4:36 pm
GilaMonster (7/21/2011)
If you want to keep the log managable, back the log up regularly and make sure there are no other problems that cause the log to grow (failed replication,...
July 21, 2011 at 3:14 pm
GilaMonster (7/21/2011)
That's still a very bad thing to do, as it means that if a full backup is not restorable you have no options for restoring to point of failure....
July 21, 2011 at 2:48 pm
Yes, backup log with truncate only is logged. I see it. There's actually a job that does this just prior to the FULL db backup.
At least the job logs...
July 21, 2011 at 1:42 pm
I hope not!
I did notice a trend that it fails at a specific time. At least the past 2 days it did. There is only one job that runs at...
July 21, 2011 at 12:42 pm
I use the WinZip commandline tool and use the Windows Scheduler to kick it off.
Like the others said, use only one compression tool. I zip a 90GB .bak file to...
July 21, 2011 at 12:03 pm
It looks like your backing up to a UNC path. Can you try backing up to a local drive?
If no space try a USB drive. I found that backing up...
July 21, 2011 at 11:53 am
THAT WAS IT!!!!
I knew I was forgetting something simple...... :hehe:
Thanks a bunch!
July 5, 2011 at 1:12 pm
Nevermind. I figured it out.
I told you it was a senior moment.
The problem was the account I creaed was missing the letter "s". So the creds SQL was passing...
June 28, 2011 at 11:21 am
True.
Then I recomend the OP package this script and do as Grasshopper sez.....
June 28, 2011 at 10:44 am
PhilipC (5/12/2011)
"Only members of the sysadmin fixed server role can specify the Auto_Fix option."
Try this on the DB *AFTER* they restore it. It's not "Auto_Fix" so it might work.....
DECLARE @username...
June 28, 2011 at 10:30 am
To get the memory SQL uses, tun the following...
SELECT
--Amount of physical memory on server
physical_memory_in_bytes
, physical_memory_in_bytes / 1024 / 1024.00 as physical_memory_in_MB
,virtual_memory_in_bytes
, virtual_memory_in_bytes / 1024 / 1024.00...
May 16, 2011 at 11:00 am
SQLMyFriend (5/12/2011)
I talked with our network guy, it's not possible for them to add another memory disk on that computer.
A network guy is managing the SQL Server????
OK, let me ask...
May 13, 2011 at 10:48 am
Viewing 15 posts - 16 through 30 (of 149 total)