Viewing 11 posts - 961 through 972 (of 972 total)
If you apply SP2 or greater to the client you have SSMS 2005 tools loaded on you should be able to connect to 2008. I am trying to...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
June 2, 2009 at 8:21 am
N'I:\\backup\\RestoreAdminData_Forest\\RestoreAdminData_Forest_backup_200905272100.bak'
Are you trying to run this job on the SQL server or through SSMS on your client machine? Have you tried going straight to it with using the UNC...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
May 31, 2009 at 11:37 pm
Completely agree...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
May 29, 2009 at 10:36 pm
If they are SQL Agent jobs then you should be able to go through SSMS and view the properties of each job to determine what they are doing.
I am not...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
May 29, 2009 at 6:58 am
Mind you I don't deal much with the data side of SQL Server. This is just my thought from studying I have done on the subject for tests and...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
May 28, 2009 at 11:31 pm
A bit more detail is needed.
You say you have reviewed some of the job scripts or jobs themselves. What type of job is it (SQL Agent Job, maintenance plan,...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
May 28, 2009 at 10:51 pm
To get a definite answer on what ports your instance is listening on try this this article out: http://support.microsoft.com/kb/294453
It shows the location the ports are actually set at. I...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
May 27, 2009 at 7:07 pm
Not that I have tried this but would be curious to know if you use it and how it works.
Microsoft has put out a free app that will assist you...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
May 27, 2009 at 12:55 pm
Not that I have tried this but would be curious to know if you use it and how it works.
Microsoft has put out a free app that will assist you...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
May 27, 2009 at 12:03 pm
A good question to ask your IT Director would be what type of recovery time is required for the database(s)?
I would agree with Steve though that backing up...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
May 27, 2009 at 11:36 am
What is the minimum editions required of SQL and Visual Studio?
Being only a VBScript person and not a full blown .NET programmer (I can read it but not really write...
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
April 20, 2009 at 6:42 am
Viewing 11 posts - 961 through 972 (of 972 total)