|
You don't.
The log contains all the information required to roll forward or back to a point in time. If you want to see what the state of the database was at a particular point in time, back up the transaction log (WITH NO_TRUNCATE to keep the current log data, so you don't affect your regular backup sequence), then restore the last full backup under a different name WITH NORECOVERY, and restore the log backup WITH RECOVERY, STOPAT and the time you want to recover up to.
The log contains binary log records indicating the operations that were performed, plus the data of any rows deleted, the new data for any rows added, and both the before and after versions of rows updated. For information on the log format used by SQL Server 2000, see the book "Inside SQL Server 2000". There's an updated set of books for SQL Server 2005 - presumably you want the Storage Engine one.
|
|
|
|
|
A trigger was mysteriously added to one of our tables. What I would like to find out is who did it (nobody is admitting it). Looks like there is no easy way to find that out?
|
|
|
|
|
Hi,
I'm working with SQL server 2005 express and Visual Studio 2005 and have a problem.
I have a Database named DataBase1 and I want to backup it.
I define a SQLcommand and after do:
myCommand.CommandText = @"BACKUP DATABASE DataBase1 TO DISK = 'C:\MyFiles\DB_BAckup.bak'";
myCommand.ExecuteNonQuery();
But It doesn't work, I get an exception "Could not locate entry...."
What does it mean?
Thanks in advance.
|
|
|
|
|
|
I'm researching the possibilities of embedding a DB inside a windows form application. I have done this before with a access DB, but not a MS sql db. I noted that this might be possible using ms sql express, but does this create a sql server instance on the client's pc? I just want to be able to install the app on a clients pc without undergoing a sql 2000/2005 server setup.
Is this possible, and how do i go about it?
Thanx ion advance.
Regards,
Tintin
|
|
|
|
|
Sql Server is called 'Server' for a reason 
Sql Server Express is just a cut down version, it's still a server though and will install an instance of the server.
If you want a good free embeded databse take a look at SQLite[^]. It's very good although it has nowhere near the functionality of Sql Server.
If you can't do without the features Sql Server provides then you can always do a silent install of Express during your own applications setup. Theres plenty of commandline arguments you can pass to fully automate and customise the installation.
|
|
|
|
|
Thats what I thought, although @ microsoft express website they say:
SQL Server 2005 Express Edition is the next version of MSDE and is a free, easy-to-use, lightweight, and embeddable version of SQL Server 2005. Free to download, free to redistribute, free to embed, and easy for new developers to use immediately....
What do they then mean by embeddable?
Will look at Sqlite as well..
Regards,
Tintin
|
|
|
|
|
SQL Server databases are loaded by the SQL Server service. SQL Server Express Edition is no different - it creates an instance by default named SQLEXPRESS. With SQL Server 2005, you can specify a database file to attach in the connection string, so it isn't permanently associated with the SQL Server instance.
Microsoft have now ported SQL Server 2005 Mobile Edition back to the desktop properly and called it SQL Server Compact Edition 3.1. This is an in-process database engine like Access/Jet. Find out more here[^]. However, this does not use the same format data files as the other SQL Server editions. (It's really only branded 'SQL Server', it has nothing in common).
|
|
|
|
|
Hi,
I have to extract a blob field from a sql database.
please help.
Thanks
|
|
|
|
|
|
When I run my program,I get these errors and I don't know how to solve it:
1.A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
2.Cannot open database "NORTHWND.MDF" requested by the login. The login failed.
dataAdapter.Fill(dataset,"Customers"); This is where the exception is thrown
I use windows authentication and the owner of database is current user.
Can anyone please help?
|
|
|
|
|
Try enabling "Named Pipes" and restart SQL.
Regards,
Hulicat
|
|
|
|
|
I tried it but it didn't help.
|
|
|
|
|
For clarity you:
Opened the SQL Server Configuration Manager, expanded the Network configuration and enabled the Shared Memory and Named Pipes?
check if VIA is disabled.
The same needs to be done in Client configuration in client protocol section.
Regards,
Hulicat
|
|
|
|
|
Hi,
try to connect to SQL Authentification.
Can you show the connection string which you use to connect to sql server?
|
|
|
|
|
Hi,
When i set a primary key to a column in a table by default it would create a clustered index for that column.
The question is: Can i set primary key for the column with no index being created.
If yes how can this be achieved?
Gautham
|
|
|
|
|
Please read first what is indexing and
what is primary key
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
What do you want to know abt that?
I know what is a primary key and what does an index do in general
Gautham
|
|
|
|
|
gauthee wrote: Can i set primary key for the column with no index being created.
Then what is the meaning of this line?
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
That is a question iam asking!
Is it possible or not?
There are two questions infact:
1) Can a primary key be set for a column with index being set?
2) Can a primary key be set for a column with a non clustered index?
Hope you understood???
Gautham
|
|
|
|
|
Still you are not understanding what i am trying to tell.
No arguments please.
Kool.... think....ba ...bye
Regards,
Sylvester G
sylvester_g_m@yahoo.com
|
|
|
|
|
No, you can't. SQL Server uses the index to determine whether the key already exists. If it didn't have an index it would have to do a (slow) table scan, i.e. read all the records in the database.
You can create the primary key index non-clustered if you prefer.
|
|
|
|
|
Mike,
Thanks for the reply!
We cannot create primary key without indexes being added to the column now that is answered.
You said a non-clustered index with a primary key, how can it be done?
Gautham
|
|
|
|
|
Primary key with non clustered index ....
ALTER TABLE TableA ADD CONSTRAINT
PK_TableA PRIMARY KEY NONCLUSTERED (ColA)
Primary key with clustered index ....
ALTER TABLE TableA ADD CONSTRAINT
PK_TableA PRIMARY KEY CLUSTERED (ColA)
Regards
KP
|
|
|
|
|
I planned to have insert, update, delete actions in the same procedure by passing a flag. If i have the things like this will it lead to any performance or debug issues
Best Regards,
M. J. Jaya Chitra
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
