Viewing 12 posts - 1 through 12 (of 12 total)
Hi Rudy,
Thanks for the article.
If you check out MS article http://support.microsoft.com/kb/937682, it is similar to your solution. At the end of MS article, it says 'Important The method...
November 4, 2009 at 10:05 pm
sql 2005 logshipping tlog file date format is using GMT. The timestamp of the file still using server system time.
example
08/17/2009 04:00 PM ...
August 17, 2009 at 3:57 pm
On Server A(report server), open SQL server configuration manager, under SQL Native Client Configuration(32bit) and SQL Native client configuration, create aliases with SQL2\ins2, IP and SQL port.
On Server B(SQL server),...
June 10, 2009 at 11:31 am
You might want to try the followings:
On Server A(report server), open SQL server configuration manager, under SQL Native Client Configuration(32bit) and SQL Native client configuration, create aliases with Server B...
June 10, 2009 at 9:54 am
config file looks ok.
On your server B, what version of SQL you have? I assume it is 64bit server as well right?
Please verify this on your SQL server
sql server...
June 10, 2009 at 8:00 am
When you defining the report server database connection, which credential type you use (Windows integrated security, windows user account or SQL server login)?
You can check RSreportserver.config file and look for...
June 9, 2009 at 8:49 pm
Tanveer,
Yes. Performance and IO is the big concern if you have very active db. I think Gail already asked u the question on how much data you could afford...
June 9, 2009 at 2:23 pm
Are you using MS native maintenance backup job right? Since you already saw those four dbs tlog backup generated on the disk but job still failed. I suspect it failed...
June 9, 2009 at 1:07 pm
Steve, you are right. If you have full backup and all tlog backups in sequence afterwards, no matter whether there is any diff backup in between or not, you can...
June 9, 2009 at 12:57 pm
very good article. it helps dba to streamline the backup and recovery process. thanks
June 9, 2009 at 8:38 am
The reason I don't highly recommend this article is because the author simply ignore the importance of SQL security. As this article let technical even non-technical people run scheduled sql...
June 8, 2009 at 10:03 am
To tell the truth, I don't think this solution is highly recommended. As we could see you are using window authentication to connect to SQL in your batch file. If...
June 5, 2009 at 8:06 am
Viewing 12 posts - 1 through 12 (of 12 total)