Viewing 15 posts - 61 through 75 (of 253 total)
true abut SQL2008. This is a test environment. Still cannot connect to SQl2008 sql server using ssma.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
March 22, 2017 at 4:46 pm
running ssma IN 32 BIT mode helped. Now this tables display when I select the MSACCESS database file.
But when I try to connect to sql server, I get...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
March 22, 2017 at 11:18 am
I'm a powershell rookie. Here is my 1st attempt.
copy-item -Path \\servera\D$\sqlbackups\*.bak -destination \\serverb\D$\sqlbackups\
When I run this in SQL Server agent, I get a successful...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
February 2, 2017 at 4:30 pm
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
January 26, 2017 at 5:46 pm
yes. BTW This blog is really good.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
January 6, 2017 at 5:03 pm
I didn't even know how to set up Sql Agent Proxies. Not rocket science, but I always enjoy learning new features.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
January 5, 2017 at 4:49 pm
It's always great to have support from a solid team. Our network group is excellent.
I am copying 1 set of backups per day to a virtual server and this...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
January 5, 2017 at 4:14 pm
Setting up a SQl Agent Proxy and using CMD exec did the trick. In this process I have learned that working with xp_cmdshell is not amusing. ...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
January 5, 2017 at 1:53 pm
Nice idea. But I prefer the CMD Exec option.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
January 5, 2017 at 1:35 pm
Yes, the service acct did not have adequate permissions. I changed it and this caused Idera Diagnostic Mgr to go south for that server. I generated a...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
December 30, 2016 at 1:33 pm
Part 2. We have 2 2008 r2 servers with 2008 r2 sql server installed on both.
Our goal is to copy the full sql server backups from server A to...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
December 27, 2016 at 4:10 pm
The last option worked. Thank you.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
December 22, 2016 at 4:40 pm
I downloaded and ran the Migration assistant. It did a nice job moving the tables. Afterwards, I logged into SQl Server Mgmt Studio and activated...
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
October 21, 2016 at 10:20 am
yes ms access 2010 and sql server 2008 r2.
When using the upsizing wizard I chose the RI option. Perhaps the triggers would have been a better choice?
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
October 19, 2016 at 10:28 am
I used the upsizing wizard. it did not preserve the RI. Thanks for asking.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
October 18, 2016 at 3:49 pm
Viewing 15 posts - 61 through 75 (of 253 total)