This blog is about my history as a software engineer utilizing technologies C#, Java, React, JavaScript, .NET Core, SQL Server , Oracle, GIT, GitHub, Jira, Azure, AWS and HTML5. “I have not failed. I've just found 10,000 ways that won't work.” Thomas A. Edison. Please click on all my ADVERTISING links to help support this blog. Thank you.
Tuesday, September 25, 2007
Blog of the Day
I am actually developing some reporting in Excel from SharePoint lists being populated by InfoPath Forms. I hope to be moving into the InfoPath to Web services to SQL server to us SQL reporting soon. I will keep everyone updated.
<moojjoo>
Thursday, September 13, 2007
Tuesday, September 11, 2007
Backup and Restore on SQL Server
thanks to moonguy on MSDN he saved me many hours of work.
When you try to backup, SQL Server 2005 shows the default backup path i.e. c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ . This directory default has SQL user rights. Go to Backup directory and check the user name. Its very big name and I have not checked how SQL server adds it in allowed users list. You can do 2 things:
1. Let the Server take backup on default directory and copy the file in your desired folder. I did that.
2. Give same kind of permissions to your desired folder as Backup directory has.
Hope it solves the issue.
Moonguy
When you try to backup, SQL Server 2005 shows the default backup path i.e. c:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\ . This directory default has SQL user rights. Go to Backup directory and check the user name. Its very big name and I have not checked how SQL server adds it in allowed users list. You can do 2 things:
1. Let the Server take backup on default directory and copy the file in your desired folder. I did that.
2. Give same kind of permissions to your desired folder as Backup directory has.
Hope it solves the issue.
Moonguy
Wednesday, September 05, 2007
Classes, Objects and Methods oh my!!!!!
I read a great article the other day for the newbies to C# and OO development http://www.devarticles.com/c/a/C-Sharp/Introduction-to-Objects-and-Classes-in-C-sharp/
Take some time to read it.
Take some time to read it.
Subscribe to:
Posts (Atom)