The backup server is using the agent to run log shipping. If I were to
migrate jobs prior to a disaster, the agent would run them. Assuming I can
turn them off so that having them run is not an issue, migrating them one at
a time is tedious.
Is there a way to mass migrate the jobs from one server to the other?
(packages are already migrated)
If such a thing as a mass import of the jobs is available, will the job
migration automatically schedule the packages or will it be necessary to
reschedule them (assuming a disaster event occurs and log-shipping is the
backup solution).
Regards,
Jamie
Hi
"thejamie" wrote:
> The backup server is using the agent to run log shipping. If I were to
> migrate jobs prior to a disaster, the agent would run them. Assuming I can
> turn them off so that having them run is not an issue, migrating them one at
> a time is tedious.
> Is there a way to mass migrate the jobs from one server to the other?
> (packages are already migrated)
>
As described in http://support.microsoft.com/kb/314546 you can script all
jobs.
> If such a thing as a mass import of the jobs is available, will the job
> migration automatically schedule the packages or will it be necessary to
> reschedule them (assuming a disaster event occurs and log-shipping is the
> backup solution).
>
Scripting will re-create the same schedules. The jobs should be enabled when
you are scripting them if you don't want to change them on the destination
server.
> --
> Regards,
> Jamie
John
|||I hadn't noticed before, but there appears to be a wizard in SQL 2005 for
this. We have our production running on 2000 and with disk space at a
premium and backup time stretched to the limit, we needed to start
compressing backups and decided to buy a package. It works great. I am
impressed to see that the 2005 version already does this. Elated actually.
Regards,
Jamie
"John Bell" wrote:
> Hi
> "thejamie" wrote:
> As described in http://support.microsoft.com/kb/314546 you can script all
> jobs.
>
> Scripting will re-create the same schedules. The jobs should be enabled when
> you are scripting them if you don't want to change them on the destination
> server.
>
> John
Showing posts with label log. Show all posts
Showing posts with label log. Show all posts
Wednesday, March 21, 2012
Migrate jobs from production to backup
The backup server is using the agent to run log shipping. If I were to
migrate jobs prior to a disaster, the agent would run them. Assuming I can
turn them off so that having them run is not an issue, migrating them one at
a time is tedious.
Is there a way to mass migrate the jobs from one server to the other?
(packages are already migrated)
If such a thing as a mass import of the jobs is available, will the job
migration automatically schedule the packages or will it be necessary to
reschedule them (assuming a disaster event occurs and log-shipping is the
backup solution).
Regards,
JamieHi
"thejamie" wrote:
> The backup server is using the agent to run log shipping. If I were to
> migrate jobs prior to a disaster, the agent would run them. Assuming I c
an
> turn them off so that having them run is not an issue, migrating them one
at
> a time is tedious.
> Is there a way to mass migrate the jobs from one server to the other?
> (packages are already migrated)
>
As described in http://support.microsoft.com/kb/314546 you can script all
jobs.
> If such a thing as a mass import of the jobs is available, will the job
> migration automatically schedule the packages or will it be necessary to
> reschedule them (assuming a disaster event occurs and log-shipping is the
> backup solution).
>
Scripting will re-create the same schedules. The jobs should be enabled when
you are scripting them if you don't want to change them on the destination
server.
> --
> Regards,
> Jamie
John|||I hadn't noticed before, but there appears to be a wizard in SQL 2005 for
this. We have our production running on 2000 and with disk space at a
premium and backup time stretched to the limit, we needed to start
compressing backups and decided to buy a package. It works great. I am
impressed to see that the 2005 version already does this. Elated actually.
--
Regards,
Jamie
"John Bell" wrote:
> Hi
> "thejamie" wrote:
>
> As described in http://support.microsoft.com/kb/314546 you can script all
> jobs.
>
> Scripting will re-create the same schedules. The jobs should be enabled wh
en
> you are scripting them if you don't want to change them on the destination
> server.
>
> John
migrate jobs prior to a disaster, the agent would run them. Assuming I can
turn them off so that having them run is not an issue, migrating them one at
a time is tedious.
Is there a way to mass migrate the jobs from one server to the other?
(packages are already migrated)
If such a thing as a mass import of the jobs is available, will the job
migration automatically schedule the packages or will it be necessary to
reschedule them (assuming a disaster event occurs and log-shipping is the
backup solution).
Regards,
JamieHi
"thejamie" wrote:
> The backup server is using the agent to run log shipping. If I were to
> migrate jobs prior to a disaster, the agent would run them. Assuming I c
an
> turn them off so that having them run is not an issue, migrating them one
at
> a time is tedious.
> Is there a way to mass migrate the jobs from one server to the other?
> (packages are already migrated)
>
As described in http://support.microsoft.com/kb/314546 you can script all
jobs.
> If such a thing as a mass import of the jobs is available, will the job
> migration automatically schedule the packages or will it be necessary to
> reschedule them (assuming a disaster event occurs and log-shipping is the
> backup solution).
>
Scripting will re-create the same schedules. The jobs should be enabled when
you are scripting them if you don't want to change them on the destination
server.
> --
> Regards,
> Jamie
John|||I hadn't noticed before, but there appears to be a wizard in SQL 2005 for
this. We have our production running on 2000 and with disk space at a
premium and backup time stretched to the limit, we needed to start
compressing backups and decided to buy a package. It works great. I am
impressed to see that the 2005 version already does this. Elated actually.
--
Regards,
Jamie
"John Bell" wrote:
> Hi
> "thejamie" wrote:
>
> As described in http://support.microsoft.com/kb/314546 you can script all
> jobs.
>
> Scripting will re-create the same schedules. The jobs should be enabled wh
en
> you are scripting them if you don't want to change them on the destination
> server.
>
> John
Friday, March 9, 2012
Microsoft.VC80.CRT.mui
I have SQL 2005, 64bit version installed with SP1. I am seeing the following
errors in the Windows event log:
Source: SideBySide Event ID: 59
Resolve Partial Assembly failed for Microsoft.VC80.CRT.mui. Reference error
message: Access is denied.
Source: SidebySide EventID: 59
Generate Activation Context failed for D:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\bin\msmdctr90.DLL. Reference error message: Access is
denied.
Source: PerfLib EventID: 1023
Windows cannot load extensible counter DLL MSSQLServerOLAPService, the first
DWORD in data section is the Windows error code.
Does anyone know what the problem is?
Thanks
--
LehrSJHello LehrSJ,
I understand that you found some SQL related events on a SQL 2005 SP1 64bit
server, and you'd like to know what this problem is.
Based on my experience, this issue could occur if the "Performance Logs and
Alerts" service runs as "Network Service", which is member of "Performance
Log Users" local user group, does not have enough permission to SQL setup
folder.
SQL Setup grants read/execute permissions to "Performance Log Users" local
user group for the DLL only. "Performance Log Users" doesn?t have any
permissions for the containing folder. Granting "List folder contents"
permission to "Performance Log Users" for the containing folder (SQL Server
binn directory) may fix this problem:
D:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\bin
D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin
If you have any update or the issue is not resolved, please feel free to
let's know. I look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks. That solved the problem.
--
LehrSJ
""privatenews"" wrote:
> Hello LehrSJ,
> I understand that you found some SQL related events on a SQL 2005 SP1 64bit
> server, and you'd like to know what this problem is.
> Based on my experience, this issue could occur if the "Performance Logs and
> Alerts" service runs as "Network Service", which is member of "Performance
> Log Users" local user group, does not have enough permission to SQL setup
> folder.
> SQL Setup grants read/execute permissions to "Performance Log Users" local
> user group for the DLL only. "Performance Log Users" doesnâ't have any
> permissions for the containing folder. Granting "List folder contents"
> permission to "Performance Log Users" for the containing folder (SQL Server
> binn directory) may fix this problem:
> D:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\bin
> D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin
> If you have any update or the issue is not resolved, please feel free to
> let's know. I look forward to your reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||I was having this problem as well on a 32 bit system and that fixed it.
Can you explain why that fixed it? I'm asking because I was also having
2 other problems that I think this fixed as well.
first one: There is a Java program that inserts updates and deletes
records in a very large table on the sql server. It spawns 12 processes
that each have a connection to the DB and every time this program ran,
2 of them would hang up and would not receive any errors. I looked and
they were no longer connected.
second one: The users of this server have pocket pcs that connect using
sql ce server with RDA. They use an app that we wrote to replicate
their data. Along with all the pushing and pulling of tables, there is
one stored procedure that the client runs on the server. Apparently
randomly this stored procedure stops working for about 30 minutes at a
time. What happens on the client is when it calls that sp, it just
hangs there maintaining it's connection until all the sudden the sp
start working again. During the 30 minutes nobody can run the sp.
Both of these problems did not exist before we got Error 59 or after it
was fixed.
Does anybody have any clue as to why this would fix these 2 problems or
has anybody experienced anything like this?
thanks,
cob
errors in the Windows event log:
Source: SideBySide Event ID: 59
Resolve Partial Assembly failed for Microsoft.VC80.CRT.mui. Reference error
message: Access is denied.
Source: SidebySide EventID: 59
Generate Activation Context failed for D:\Program Files\Microsoft SQL
Server\MSSQL.2\OLAP\bin\msmdctr90.DLL. Reference error message: Access is
denied.
Source: PerfLib EventID: 1023
Windows cannot load extensible counter DLL MSSQLServerOLAPService, the first
DWORD in data section is the Windows error code.
Does anyone know what the problem is?
Thanks
--
LehrSJHello LehrSJ,
I understand that you found some SQL related events on a SQL 2005 SP1 64bit
server, and you'd like to know what this problem is.
Based on my experience, this issue could occur if the "Performance Logs and
Alerts" service runs as "Network Service", which is member of "Performance
Log Users" local user group, does not have enough permission to SQL setup
folder.
SQL Setup grants read/execute permissions to "Performance Log Users" local
user group for the DLL only. "Performance Log Users" doesn?t have any
permissions for the containing folder. Granting "List folder contents"
permission to "Performance Log Users" for the containing folder (SQL Server
binn directory) may fix this problem:
D:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\bin
D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin
If you have any update or the issue is not resolved, please feel free to
let's know. I look forward to your reply.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks. That solved the problem.
--
LehrSJ
""privatenews"" wrote:
> Hello LehrSJ,
> I understand that you found some SQL related events on a SQL 2005 SP1 64bit
> server, and you'd like to know what this problem is.
> Based on my experience, this issue could occur if the "Performance Logs and
> Alerts" service runs as "Network Service", which is member of "Performance
> Log Users" local user group, does not have enough permission to SQL setup
> folder.
> SQL Setup grants read/execute permissions to "Performance Log Users" local
> user group for the DLL only. "Performance Log Users" doesnâ't have any
> permissions for the containing folder. Granting "List folder contents"
> permission to "Performance Log Users" for the containing folder (SQL Server
> binn directory) may fix this problem:
> D:\Program Files\Microsoft SQL Server\MSSQL.1\mssql\bin
> D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin
> If you have any update or the issue is not resolved, please feel free to
> let's know. I look forward to your reply.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||I was having this problem as well on a 32 bit system and that fixed it.
Can you explain why that fixed it? I'm asking because I was also having
2 other problems that I think this fixed as well.
first one: There is a Java program that inserts updates and deletes
records in a very large table on the sql server. It spawns 12 processes
that each have a connection to the DB and every time this program ran,
2 of them would hang up and would not receive any errors. I looked and
they were no longer connected.
second one: The users of this server have pocket pcs that connect using
sql ce server with RDA. They use an app that we wrote to replicate
their data. Along with all the pushing and pulling of tables, there is
one stored procedure that the client runs on the server. Apparently
randomly this stored procedure stops working for about 30 minutes at a
time. What happens on the client is when it calls that sp, it just
hangs there maintaining it's connection until all the sudden the sp
start working again. During the 30 minutes nobody can run the sp.
Both of these problems did not exist before we got Error 59 or after it
was fixed.
Does anybody have any clue as to why this would fix these 2 problems or
has anybody experienced anything like this?
thanks,
cob
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the
Hi,
I am getting the following errors in my reporting server log. Can anyone help me?
ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 10., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 10.
ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 14., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 14.
ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 18., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 18.
ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 22., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 22.
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for
Hi,
I am getting the following errors in my reporting server log. Can anyone help me?
ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 10., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 10.
ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 14., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 14.
ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 18., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 18.
ReportingServicesService!processing!11!8/22/2006-01:04:04:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 22., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: There is no data for the field at position 22.
Wednesday, March 7, 2012
Microsoft Web Data Administrator, hangs on log in
Hi
I have downloaded MS Web Data Administrator to conenct to my MSDE
database. It hangs when i login using "SQL Login"
When i open up Web Data Administrator, it defaults to Port 80 and
Cassini Personal Web Server (the "IIS" button has been disabled).
Once I start Web DA with this information, and enter in the following
under an "SQL login"
Username: sa
Password: ****
Server: myServerName\myMSDEDatabase
and press "Login" it does nothing (seems to hang) and im left on the
log in page...I never get an error message, it just keeps on trying to
log in, i presume.
I am running MSDE on Win 2000 Server. MSDE is set up to use SQL
authentication (instead of Windows)
Any suggestions?
--Pam
Hi, I found this floating around on the web and did as it instructed,
but it still doesn't work!
___________________________________________
Christopher Hill Feb 7, 6:40 am show options
Newsgroups: microsoft.public.sqlserver.msde
From: "Christopher Hill" <min...@.ntlworld.com> - Find messages by this
author
Date: Mon, 7 Feb 2005 03:40:46 -0800
Local: Mon,Feb 7 2005 6:40 am
Subject: SOLUTION: SQL Web Data Administrator hangs on login
Reply to Author | Forward | Print | View Thread | Show original |
Report Abuse
(Also posted to
http://register.microsoft.com/=ADmswish/suggestion.asp)
The SQL Web Data Administrator (available here:
http://www.microsoft.com/downl=ADoad...C03=AD9A798-C=
57...
2A332CB7F959&displaylang=3Den) is a very useful tool, but
there is a problem when it is installed with the .net
Framework 1.1 with Service Pack 1. The copy of
WebUIValidation.js that is included with the Web Data
Administrator is out of date and means that it hangs when
you click the 'login' button. If you copy the updated
WebUIValidation.js file from
WINDOWS\Microsoft.NET\Framewor=ADk\v1.1.4322
\ASP.NETClientFiles into {SQL Web Administrator
installation path}\Web\aspnet_client\system=AD_web\1_1_4322\
then the problem with hanging is instantly solved.
Message to Microsoft: Please could you update the SQL Web
Administrator package to fix this problem?
By the way, this is not my solution - I found it on
http://sqljunkies.com/Forums/S=ADhow...PostID=3D2084.
|||Oops, ID-10-T error (IDIOT error!)
the fix I posted above does work, I must have been copying it in the
wrong spot or the copy hadn't "kicked in" just yet.
But the fix truly does work!
--Pam
I have downloaded MS Web Data Administrator to conenct to my MSDE
database. It hangs when i login using "SQL Login"
When i open up Web Data Administrator, it defaults to Port 80 and
Cassini Personal Web Server (the "IIS" button has been disabled).
Once I start Web DA with this information, and enter in the following
under an "SQL login"
Username: sa
Password: ****
Server: myServerName\myMSDEDatabase
and press "Login" it does nothing (seems to hang) and im left on the
log in page...I never get an error message, it just keeps on trying to
log in, i presume.
I am running MSDE on Win 2000 Server. MSDE is set up to use SQL
authentication (instead of Windows)
Any suggestions?
--Pam
Hi, I found this floating around on the web and did as it instructed,
but it still doesn't work!
___________________________________________
Christopher Hill Feb 7, 6:40 am show options
Newsgroups: microsoft.public.sqlserver.msde
From: "Christopher Hill" <min...@.ntlworld.com> - Find messages by this
author
Date: Mon, 7 Feb 2005 03:40:46 -0800
Local: Mon,Feb 7 2005 6:40 am
Subject: SOLUTION: SQL Web Data Administrator hangs on login
Reply to Author | Forward | Print | View Thread | Show original |
Report Abuse
(Also posted to
http://register.microsoft.com/=ADmswish/suggestion.asp)
The SQL Web Data Administrator (available here:
http://www.microsoft.com/downl=ADoad...C03=AD9A798-C=
57...
2A332CB7F959&displaylang=3Den) is a very useful tool, but
there is a problem when it is installed with the .net
Framework 1.1 with Service Pack 1. The copy of
WebUIValidation.js that is included with the Web Data
Administrator is out of date and means that it hangs when
you click the 'login' button. If you copy the updated
WebUIValidation.js file from
WINDOWS\Microsoft.NET\Framewor=ADk\v1.1.4322
\ASP.NETClientFiles into {SQL Web Administrator
installation path}\Web\aspnet_client\system=AD_web\1_1_4322\
then the problem with hanging is instantly solved.
Message to Microsoft: Please could you update the SQL Web
Administrator package to fix this problem?
By the way, this is not my solution - I found it on
http://sqljunkies.com/Forums/S=ADhow...PostID=3D2084.
|||Oops, ID-10-T error (IDIOT error!)
the fix I posted above does work, I must have been copying it in the
wrong spot or the copy hadn't "kicked in" just yet.
But the fix truly does work!
--Pam
Friday, February 24, 2012
Microsoft SQL Transaction Log
Can any one recommend a good Transaction Log viewer / analyzer for
Microsoft SQL?Check out www.lumigent.com.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<matthew.mccarty@.foxtg.com> wrote in message
news:1144852551.532336.105040@.j33g2000cwa.googlegroups.com...
Can any one recommend a good Transaction Log viewer / analyzer for
Microsoft SQL?|||Thanks for the link.
Can LogExplorer view logs that where created before the software is
installed on the server?
Thanks,
Matt|||I believe so. You may want to contact them directly.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Traxs" <matthew.mccarty@.foxtg.com> wrote in message
news:1144854286.523969.275510@.v46g2000cwv.googlegroups.com...
Thanks for the link.
Can LogExplorer view logs that where created before the software is
installed on the server?
Thanks,
Matt|||<matthew.mccarty@.foxtg.com> wrote in message
news:1144852551.532336.105040@.j33g2000cwa.googlegroups.com...
> Can any one recommend a good Transaction Log viewer / analyzer for
> Microsoft SQL?
>
Here is a FREE one:
SELECT * FROM ::fn_dblog(NULL, NULL)
The params are Start LSN and End LSN respectivly.
Microsoft SQL?Check out www.lumigent.com.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<matthew.mccarty@.foxtg.com> wrote in message
news:1144852551.532336.105040@.j33g2000cwa.googlegroups.com...
Can any one recommend a good Transaction Log viewer / analyzer for
Microsoft SQL?|||Thanks for the link.
Can LogExplorer view logs that where created before the software is
installed on the server?
Thanks,
Matt|||I believe so. You may want to contact them directly.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Traxs" <matthew.mccarty@.foxtg.com> wrote in message
news:1144854286.523969.275510@.v46g2000cwv.googlegroups.com...
Thanks for the link.
Can LogExplorer view logs that where created before the software is
installed on the server?
Thanks,
Matt|||<matthew.mccarty@.foxtg.com> wrote in message
news:1144852551.532336.105040@.j33g2000cwa.googlegroups.com...
> Can any one recommend a good Transaction Log viewer / analyzer for
> Microsoft SQL?
>
Here is a FREE one:
SELECT * FROM ::fn_dblog(NULL, NULL)
The params are Start LSN and End LSN respectivly.
Microsoft SQL Transaction Log
Can any one recommend a good Transaction Log viewer / analyzer for
Microsoft SQL?Check out www.lumigent.com.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<matthew.mccarty@.foxtg.com> wrote in message
news:1144852551.532336.105040@.j33g2000cwa.googlegroups.com...
Can any one recommend a good Transaction Log viewer / analyzer for
Microsoft SQL?|||Thanks for the link.
Can LogExplorer view logs that where created before the software is
installed on the server?
Thanks,
Matt|||I believe so. You may want to contact them directly.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Traxs" <matthew.mccarty@.foxtg.com> wrote in message
news:1144854286.523969.275510@.v46g2000cwv.googlegroups.com...
Thanks for the link.
Can LogExplorer view logs that where created before the software is
installed on the server?
Thanks,
Matt|||<matthew.mccarty@.foxtg.com> wrote in message
news:1144852551.532336.105040@.j33g2000cwa.googlegroups.com...
> Can any one recommend a good Transaction Log viewer / analyzer for
> Microsoft SQL?
>
Here is a FREE one:
SELECT * FROM ::fn_dblog(NULL, NULL)
The params are Start LSN and End LSN respectivly.
Microsoft SQL?Check out www.lumigent.com.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
<matthew.mccarty@.foxtg.com> wrote in message
news:1144852551.532336.105040@.j33g2000cwa.googlegroups.com...
Can any one recommend a good Transaction Log viewer / analyzer for
Microsoft SQL?|||Thanks for the link.
Can LogExplorer view logs that where created before the software is
installed on the server?
Thanks,
Matt|||I believe so. You may want to contact them directly.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Traxs" <matthew.mccarty@.foxtg.com> wrote in message
news:1144854286.523969.275510@.v46g2000cwv.googlegroups.com...
Thanks for the link.
Can LogExplorer view logs that where created before the software is
installed on the server?
Thanks,
Matt|||<matthew.mccarty@.foxtg.com> wrote in message
news:1144852551.532336.105040@.j33g2000cwa.googlegroups.com...
> Can any one recommend a good Transaction Log viewer / analyzer for
> Microsoft SQL?
>
Here is a FREE one:
SELECT * FROM ::fn_dblog(NULL, NULL)
The params are Start LSN and End LSN respectivly.
microsoft SQL Server, Error: 500
One or more files listed in the statement could not be found or could not be initialized.
I was trying to remove one of my test log files. But every time I try to remove it this error keeps on showing up.. Can someone please help me regarding this problem.
Thanks in Advance.Could U please suply more information ?? error code 500 could mean anything. Please provide the command/ sql youre trying to execute
Subscribe to:
Posts (Atom)