Showing posts with label step. Show all posts
Showing posts with label step. Show all posts

Tuesday, March 27, 2012

Database snapshot SQL Server 2005

Hello Every

I have a problem withASP.NET connect toDatabase Snapshot SQL Server 2005.

Step One: I create database snapshot.

Step Two: I want to use ASP.NET to Database Snapshot that create already. But I don't know connection string to database snapshot.

Please help me .....................

Thank You,

I also have the same problem as follows:

The first execute of SQL Server 2005 tasks to creates the snapshot as follows:

USE Master;
GO
IF EXITS (SELECT name FROM sys.database WHERE name = "N'source_system_snapshot_extract')
BEGIN
DROP DATABASE [source_system_snapshot_extract]
END
GO
CREATE DATABASE source_system_snapshot_extract ON
('C:\Test\source_system_snapshot_extract.ss)
AS SNAPSHOT OF source_system
GO

The second I want code in the ASP.NET to connect to the database snapshot replication above

Please post your example code if anyone can solve this problem.

|||

In the ASP.NET from the code design , i write the code as follow:

Imports Microsoft.SqlServer.Dts.Runtime

Public Sub Main()

Dim Constr$=Dts.connections("Source_System").connectionstring

If not Constr.contain("Initial Catalog=Source_System") then

Dts.taskresult=dts.results.failure

return

Endif

Dts.connections("Source_System").connectionstring=Dts.connections("Source_System").connectionstring.replace("Initial Catalog=Source_System", ("Initial Catalog=Source_System_Snapshot_Extract")

Dts.taskresult=dts.results.Success

End sub

The code above does not response correctly to have the database snapshot connect to asp.net

However ,DTS does not show up in code.

Please held me to resolve this .

|||

With your above code, I have write the same code using the Visual Studion IDE, then I have added a reference as follows:

Microsoft.SqlServer.ManagedDTS.DLL

To add the reference above, it is in order to create using statement as discussed in the above code, but it is not possible to display the right statement. I think someone in Microsoft with SQL Server 2005 Specialist will help us to code this. The crucial help from Microsoft will be usefull the programmers over the world.

|||

Thanks alot that you try to help me.

but i still got a problem i can't connect to database snapshot with VB.NET.

Microsoft said that we can do database with database snapshot . but try to find any sample on the internet websit i can't found about that problem , How to connect to database snapshot with VB.NET.

i don't belive in that The Microsoft speak a lie all of customers that support his product, but i am not sure untill he solve this problem , to indicate

me to know or all of programmer in the world.

i hope that someone in Microsoft with SQL Server 2005 Specialist will help this.

|||

I try helping to solve this problem, but i have still not yet find the solution. I think that there will be another specialist like moderator, contributor or commentator of this web site will help you to solve this problem. I have read some technical notes regarding to your needs I hope SQL Server Specialist from Microsoft will assist you to resolve your problem.

If Database Snapshot Replication has no connection with VB.NET, I believe that the SQL Server 2005 programmer within Microsoft was not hosted this project in SQL Server 2005 Project.

|||

I understand your concepts related to the database snapshot to create just the read-only databases for viewing the reports. This is no need to use the original database with SQL Server 2005 install to come along with your backage, but I have some link to talk about database snapshot, but this web is not talking the database snapshot connecting with VB.NET (http://articles.techrepublic.com.com/5100-9592_11-6146916.html), (http://www.code-magazine.com/article.aspx?quickid=0311101&page=4), also see this link:http://sqljunkies.com/WebLog/marathonsqlguy/archive/2006/05.aspx. I think there is no way to code from VB.NET to connect the database snapshot out of the original database.

I probably am poor with this coding, I hope someone in this site will save you to code this and attached with nice example project.

|||

?????????????????? ?????????????????????????????????????http://www.c-sharpcorner.com/UploadFile/paulyau/DBOpsInADOPA11302005071252AM/DBOpsInADOPA.aspx

|||

Please read this link:https://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1149179&SiteID=1 , I think it is useful for you.

|||

Also see this link:http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=63581&SiteID=17

|||

This is also useful link:http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1458445&SiteID=1

|||

See this help you:http://msdn2.microsoft.com/zh-cn/library/microsoft.sqlserver.management.smo.database.isdatabasesnapshot.aspx

|||

Is this link help you:http://support.microsoft.com/kb/319649 orhttp://support.microsoft.com/kb/319648/

|||

This topic is still error. Please help me

Wednesday, March 7, 2012

Database restore

Hi All,

I am trying to restore a database from backup on another system [my
client's] but I had to follow some weired steps.

Step 1. Restore the database from EM 's GUI.
[Users as on My machine get restored but their logins are not
activated. So I have to follow the next steps]

sp_helpuser shows me the userName but null LoginName and
DefaultDatabase

Step 2. Create a new login , grant access to the DB

Step 3. Then run the script to change the ownership from earlier DB
user to new user.

Step 4. In EM make new user as dbo.

Really weired steps.

There should be easier way to restore the database in simple and
effective manner

With warm regards
Jatinderjsfromynr (jatinder.singh@.clovertechnologies.com) writes:
> I am trying to restore a database from backup on another system [my
> client's] but I had to follow some weired steps.
> Step 1. Restore the database from EM 's GUI.
> [Users as on My machine get restored but their logins are not
> activated. So I have to follow the next steps]
> sp_helpuser shows me the userName but null LoginName and
> DefaultDatabase
> Step 2. Create a new login , grant access to the DB
> Step 3. Then run the script to change the ownership from earlier DB
> user to new user.
> Step 4. In EM make new user as dbo.

Look at sp_change_users_login in Books Online.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks Erland,
It worked, I have another problem
by mistake I created all of my table in a user not as SA.so I tried
this to change the ownership

select 'EXEC sp_changeobjectowner oldusername'+
char(39)+name+char(39)+','+ char(39) +'dbo'+char(39) from sysobjects
where uid=6 {old user's ID}

It works but I am looking for some easy methods

With warm regards
Jatinder|||jsfromynr (jatinder.singh@.clovertechnologies.com) writes:
> It worked, I have another problem
> by mistake I created all of my table in a user not as SA.so I tried
> this to change the ownership
> select 'EXEC sp_changeobjectowner oldusername'+
> char(39)+name+char(39)+','+ char(39) +'dbo'+char(39) from sysobjects
> where uid=6 {old user's ID}
>
> It works but I am looking for some easy methods

It can't get any easier than that!

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp