Active Directory has killed Replication...

Hi folks,
We've just upgraded our SQL servers to active directory. Have deleted all
of the existing jobs and replications before upgrading, as one is supposed
to do, but now when I create a new replication it just fails, saying it
can't find the distribution server specified.
The snapshot is failing at the Run agent step with "The process could not
create file '\\DIVCS-SQL1\F$\Replication\unc'. The step failed.", where
DIVCS-SQL1 is the old name of the server.
When I go to the configuration screen for the replication agent it shows the
old server name as the Distribution Server name (DIVCS-SQL1)
I assume that there is a registry item that points SQL server to the right
agent, but I don't want to start playing with it without some advice...
Thanks in advance...
Paul
Paul,
Try:
Use Master
go
Select @.@.Servername
This should return your current server name but if it
returns NULL or the oldname then try:
Use Master
go
Sp_DropServer 'Server1'
GO
Use Master
go
Sp_Addserver 'Server1', 'local'
GO
Stop and Start SQL Services
NB: You can use the @.@.SERVERNAME global variable or the SERVERPROPERTY('ServerName') function in SQL Server to find the network name of the computer running SQL Server. The ServerName property of the SERVERPROPERTY function automatically reports the chang
e in the network name of the computer when you restart the computer and the SQL Server service. The @.@.SERVERNAME global variable retains the original SQL Server computer name until the SQL Server name is manually reset.
HTH,
Paul Ibison
|||Hi,
Just tried sp_dropserver and got the following error message :
"Server: Msg 20582, Level 16, State 1, Procedure sp_MSrepl_check_server,
Line 39
Cannot drop server 'DIVCS-SQL1' because it is used as a Publisher in
replication."
I tried the 'droplogins' parameter as well, but to no avail.
Any ideas?
Cheers...P
"Paul Ibison" <Paul.Ibison@.Pygmalion.com> wrote in message
news:84A80174-EB3D-4414-9288-C84A01B6C72E@.microsoft.com...
> Paul,
> Try:
> Use Master
> go
> Select @.@.Servername
> This should return your current server name but if it
> returns NULL or the oldname then try:
> Use Master
> go
> Sp_DropServer 'Server1'
> GO
> Use Master
> go
> Sp_Addserver 'Server1', 'local'
> GO
> Stop and Start SQL Services
> NB: You can use the @.@.SERVERNAME global variable or the
SERVERPROPERTY('ServerName') function in SQL Server to find the network name
of the computer running SQL Server. The ServerName property of the
SERVERPROPERTY function automatically reports the change in the network name
of the computer when you restart the computer and the SQL Server service.
The @.@.SERVERNAME global variable retains the original SQL Server computer
name until the SQL Server name is manually reset.
> HTH,
> Paul Ibison
>
|||Paul,
am I right in saying that
Select @.@.Servername
Select SERVERPROPERTY('ServerName')
return different values?
This is the case I mentioned when you need to update the value in sysservers.
If this is so, then it means that you have set up replication on a renamed server, or you have set up replication then renamed the server. The simplest method to solve the issue is to drop the publications, disable replication, update sysservers using the
script in my previous post, then recreate the publications.
HTH,
Paul Ibison
|||Phew...Got it working.
Thanks for your help...I kind of got it...eventually.
P
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:016D7C4C-5BAF-416F-87E6-0184DE7FD002@.microsoft.com...
> Paul,
> am I right in saying that
> Select @.@.Servername
> Select SERVERPROPERTY('ServerName')
> return different values?
> This is the case I mentioned when you need to update the value in
sysservers.
> If this is so, then it means that you have set up replication on a renamed
server, or you have set up replication then renamed the server. The simplest
method to solve the issue is to drop the publications, disable replication,
update sysservers using the script in my previous post, then recreate the
publications.
> HTH,
> Paul Ibison

Acessing deleted records

Hi

First i'd like to say that i dont really know if it is possible to acess this, but since i've been told that some database system sometimes only "flag" record as deleted to delete them later and that i would need to possibly acess this data for a work im doing, it would be interesting for me if somebody had the asnwer i seek.

Do you know if there is a way under sql server 2000/2005 acess those data?

In SQL Server 2005 you could use OUTPUT clause (http://msdn2.microsoft.com/en-us/library/ms177564.aspx):

Code Snippet

DELETE Sales.ShoppingCartItem
OUTPUT DELETED.* ;

In SQL Server 2000 you could create on delete trigger and use "virtual table" deleted

|||

Ok, i was not very clear in the first post, my bad.

Is it possible to acess deleted data, after it was deleted, and by that i mean : Someguy delete a record, and at the end of the week i want to know how much or what data has been deleted if it has not yet been deleted physically.

And i would prefer not to use trigger since i would have to make one for each and every hundreds table of the same number of databases.

|||

No, data is deleted physically in SQL Server as soon as the statement is committed. You *can* look in the logs to see what has been deleted using a third party tool like http://www.apexsql.com/sql_tools_log.asp, but I would only suggest that as a detective tool, not a common surveilance method, especially since you should be dumping your log fairly often as a method of recovery. It will also not record who delete the row, only that it has been deleted. If you want deletes to be logical and not physical, you would have to prepare this in your design and implement it yourself.

A trigger is really your best option for logging changes. Creating a trigger for all tables is a pain, but you might be able to build them without much trouble by using the information_schema and system views (or system tables in 2000). You can find out the tablename, the columns, etc and build the triggers using a standard template without a tremendous amount of work.

For just what data is different, you could try something like http://www.red-gate.com/products/SQL_Data_Compare/index.htm. It might be too slow for you if you have a lot of data. It also cannot tell you what has been deleted.

|||

For those who would like to know i found the solution to get what i wanted :

The command sp_spaceused give a lot of information about a table or a database including the unused space and row count.

Knowing that i was able to get the number of deleted record by comparing the size taken by undeleted row.

Accidently deleted user

Hi,
I accidently deleted two users from a SQL Server database (from the
database, not from the server). It's the server for a MS CRM 1.2 system,
but that doesn't really matter...
I tried to recover them by restoring a backup for the database, but that
doesn't seam to help.
I tried to recreate the user in the database but I get an error that the
user (a windows user) already exists.
So what can I do? How can I use a backup to restore the permissions? How
can I recreate the user (they are stil used in other DBs) in the
database?
THANKS,
Thomas Pagel, Senior Consultant Business Intelligence
----
Software4You Planungssysteme GmbH
Hauptstr. 35
33178 Borchen
Germany
Tel: +49 5251 54009 11
Fax: +49 5251 54009 99
Mobil: +49 172 8423035
Homepage: www.software4you.com
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!All you should have had to do was recreate the users in the database and map
them to a login. Restoring the database should have been enough but you
might have needed to use sp_change_users_login to map the user to a login.
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
Andrew J. Kelly SQL MVP
"Thomas Pagel" <tpagel@.only.mail.no.spam.software4you.com> wrote in message
news:eaFN1aeaEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I accidently deleted two users from a SQL Server database (from the
> database, not from the server). It's the server for a MS CRM 1.2 system,
> but that doesn't really matter...
> I tried to recover them by restoring a backup for the database, but that
> doesn't seam to help.
> I tried to recreate the user in the database but I get an error that the
> user (a windows user) already exists.
> So what can I do? How can I use a backup to restore the permissions? How
> can I recreate the user (they are stil used in other DBs) in the
> database?
> THANKS,
>
> Thomas Pagel, Senior Consultant Business Intelligence
> ----
> Software4You Planungssysteme GmbH
> Hauptstr. 35
> 33178 Borchen
> Germany
> Tel: +49 5251 54009 11
> Fax: +49 5251 54009 99
> Mobil: +49 172 8423035
> Homepage: www.software4you.com
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Have you tried use sp_change_users_login in the database where the users
were deleted?
See BOL for full info.
hth
"Thomas Pagel" <tpagel@.only.mail.no.spam.software4you.com> wrote in message
news:eaFN1aeaEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I accidently deleted two users from a SQL Server database (from the
> database, not from the server). It's the server for a MS CRM 1.2 system,
> but that doesn't really matter...
> I tried to recover them by restoring a backup for the database, but that
> doesn't seam to help.
> I tried to recreate the user in the database but I get an error that the
> user (a windows user) already exists.
> So what can I do? How can I use a backup to restore the permissions? How
> can I recreate the user (they are stil used in other DBs) in the
> database?
> THANKS,
>
> Thomas Pagel, Senior Consultant Business Intelligence
> ----
> Software4You Planungssysteme GmbH
> Hauptstr. 35
> 33178 Borchen
> Germany
> Tel: +49 5251 54009 11
> Fax: +49 5251 54009 99
> Mobil: +49 172 8423035
> Homepage: www.software4you.com
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!|||Thanks for everyone... Seams to work now...
Thomas Pagel, Senior Consultant Business Intelligence
----
Software4You Planungssysteme GmbH
Hauptstr. 35
33178 Borchen
Germany
Tel: +49 5251 54009 11
Fax: +49 5251 54009 99
Mobil: +49 172 8423035
Homepage: www.software4you.com
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Accidently deleted user

Hi,
I accidently deleted two users from a SQL Server database (from the
database, not from the server). It's the server for a MS CRM 1.2 system,
but that doesn't really matter...
I tried to recover them by restoring a backup for the database, but that
doesn't seam to help.
I tried to recreate the user in the database but I get an error that the
user (a windows user) already exists.
So what can I do? How can I use a backup to restore the permissions? How
can I recreate the user (they are stil used in other DBs) in the
database?
THANKS,
Thomas Pagel, Senior Consultant Business Intelligence
Software4You Planungssysteme GmbH
Hauptstr. 35
33178 Borchen
Germany
Tel: +49 5251 54009 11
Fax: +49 5251 54009 99
Mobil: +49 172 8423035
Homepage: www.software4you.com
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
All you should have had to do was recreate the users in the database and map
them to a login. Restoring the database should have been enough but you
might have needed to use sp_change_users_login to map the user to a login.
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
Andrew J. Kelly SQL MVP
"Thomas Pagel" <tpagel@.only.mail.no.spam.software4you.com> wrote in message
news:eaFN1aeaEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I accidently deleted two users from a SQL Server database (from the
> database, not from the server). It's the server for a MS CRM 1.2 system,
> but that doesn't really matter...
> I tried to recover them by restoring a backup for the database, but that
> doesn't seam to help.
> I tried to recreate the user in the database but I get an error that the
> user (a windows user) already exists.
> So what can I do? How can I use a backup to restore the permissions? How
> can I recreate the user (they are stil used in other DBs) in the
> database?
> THANKS,
>
> Thomas Pagel, Senior Consultant Business Intelligence
> ----
> Software4You Planungssysteme GmbH
> Hauptstr. 35
> 33178 Borchen
> Germany
> Tel: +49 5251 54009 11
> Fax: +49 5251 54009 99
> Mobil: +49 172 8423035
> Homepage: www.software4you.com
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Have you tried use sp_change_users_login in the database where the users
were deleted?
See BOL for full info.
hth
"Thomas Pagel" <tpagel@.only.mail.no.spam.software4you.com> wrote in message
news:eaFN1aeaEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I accidently deleted two users from a SQL Server database (from the
> database, not from the server). It's the server for a MS CRM 1.2 system,
> but that doesn't really matter...
> I tried to recover them by restoring a backup for the database, but that
> doesn't seam to help.
> I tried to recreate the user in the database but I get an error that the
> user (a windows user) already exists.
> So what can I do? How can I use a backup to restore the permissions? How
> can I recreate the user (they are stil used in other DBs) in the
> database?
> THANKS,
>
> Thomas Pagel, Senior Consultant Business Intelligence
> ----
> Software4You Planungssysteme GmbH
> Hauptstr. 35
> 33178 Borchen
> Germany
> Tel: +49 5251 54009 11
> Fax: +49 5251 54009 99
> Mobil: +49 172 8423035
> Homepage: www.software4you.com
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||Thanks for everyone... Seams to work now...
Thomas Pagel, Senior Consultant Business Intelligence
Software4You Planungssysteme GmbH
Hauptstr. 35
33178 Borchen
Germany
Tel: +49 5251 54009 11
Fax: +49 5251 54009 99
Mobil: +49 172 8423035
Homepage: www.software4you.com
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Accidently deleted user

Hi,
I accidently deleted two users from a SQL Server database (from the
database, not from the server). It's the server for a MS CRM 1.2 system,
but that doesn't really matter...
I tried to recover them by restoring a backup for the database, but that
doesn't seam to help.
I tried to recreate the user in the database but I get an error that the
user (a windows user) already exists.
So what can I do? How can I use a backup to restore the permissions? How
can I recreate the user (they are stil used in other DBs) in the
database?
THANKS,
Thomas Pagel, Senior Consultant Business Intelligence
----
Software4You Planungssysteme GmbH
Hauptstr. 35
33178 Borchen
Germany
Tel: +49 5251 54009 11
Fax: +49 5251 54009 99
Mobil: +49 172 8423035
Homepage: www.software4you.com
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!All you should have had to do was recreate the users in the database and map
them to a login. Restoring the database should have been enough but you
might have needed to use sp_change_users_login to map the user to a login.
http://www.support.microsoft.com/?id=298897 Mapping Logins & SIDs after a
Restore
http://www.dbmaint.com/SyncSqlLogins.asp Utility to map logins to
users
http://www.support.microsoft.com/?id=168001 User Logon and/or Permission
Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872 How to Resolve Permission
Issues When a Database Is Moved Between SQL Servers
Andrew J. Kelly SQL MVP
"Thomas Pagel" <tpagel@.only.mail.no.spam.software4you.com> wrote in message
news:eaFN1aeaEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I accidently deleted two users from a SQL Server database (from the
> database, not from the server). It's the server for a MS CRM 1.2 system,
> but that doesn't really matter...
> I tried to recover them by restoring a backup for the database, but that
> doesn't seam to help.
> I tried to recreate the user in the database but I get an error that the
> user (a windows user) already exists.
> So what can I do? How can I use a backup to restore the permissions? How
> can I recreate the user (they are stil used in other DBs) in the
> database?
> THANKS,
>
> Thomas Pagel, Senior Consultant Business Intelligence
> ----
> Software4You Planungssysteme GmbH
> Hauptstr. 35
> 33178 Borchen
> Germany
> Tel: +49 5251 54009 11
> Fax: +49 5251 54009 99
> Mobil: +49 172 8423035
> Homepage: www.software4you.com
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!|||Have you tried use sp_change_users_login in the database where the users
were deleted?
See BOL for full info.
hth
"Thomas Pagel" <tpagel@.only.mail.no.spam.software4you.com> wrote in message
news:eaFN1aeaEHA.1356@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I accidently deleted two users from a SQL Server database (from the
> database, not from the server). It's the server for a MS CRM 1.2 system,
> but that doesn't really matter...
> I tried to recover them by restoring a backup for the database, but that
> doesn't seam to help.
> I tried to recreate the user in the database but I get an error that the
> user (a windows user) already exists.
> So what can I do? How can I use a backup to restore the permissions? How
> can I recreate the user (they are stil used in other DBs) in the
> database?
> THANKS,
>
> Thomas Pagel, Senior Consultant Business Intelligence
> ----
> Software4You Planungssysteme GmbH
> Hauptstr. 35
> 33178 Borchen
> Germany
> Tel: +49 5251 54009 11
> Fax: +49 5251 54009 99
> Mobil: +49 172 8423035
> Homepage: www.software4you.com
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!|||Thanks for everyone... Seams to work now...
Thomas Pagel, Senior Consultant Business Intelligence
----
Software4You Planungssysteme GmbH
Hauptstr. 35
33178 Borchen
Germany
Tel: +49 5251 54009 11
Fax: +49 5251 54009 99
Mobil: +49 172 8423035
Homepage: www.software4you.com
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Accidently delete records

Hello All,
I'm need help!
I have accidently deleted all record from a table. I don't have a backup at the time I deleted. Could you all tell me if there's a way to recover those records?
Thanks.
David
You may be able to use your transaction logs to do a point in time restore,
I'm not sure, but there is hope.
"David" <David@.discussions.microsoft.com> wrote in message
news:37E4E743-B412-4BF9-BFE2-69D4AA671891@.microsoft.com...
> Hello All,
> I'm need help!
> I have accidently deleted all record from a table. I don't have a backup
at the time I deleted. Could you all tell me if there's a way to recover
those records?
> Thanks.
> David
|||Lyle,
How do I do that? Could you please share some hint?
"Lyle Spencer" wrote:

> You may be able to use your transaction logs to do a point in time restore,
> I'm not sure, but there is hope.
> "David" <David@.discussions.microsoft.com> wrote in message
> news:37E4E743-B412-4BF9-BFE2-69D4AA671891@.microsoft.com...
> at the time I deleted. Could you all tell me if there's a way to recover
> those records?
>
>
|||YOu will need to take your full backups and apply the
trans logs up to the point in time you deleted the table
and you can then retrieve the records.
Here's an example from BOL
-- Restore the database backup.
RESTORE DATABASE MyNwind
FROM MyNwind_1, MyNwind_2
WITH NORECOVERY
GO
RESTORE LOG MyNwind
FROM MyNwind_log1
WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
GO
RESTORE LOG MyNwind
FROM MyNwind_log2
WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
[vbcol=seagreen]
>--Original Message--
>Lyle,
>How do I do that? Could you please share some hint?
>
>"Lyle Spencer" wrote:
point in time restore,[vbcol=seagreen]
message[vbcol=seagreen]
69D4AA671891@.microsoft.com...[vbcol=seagreen]
don't have a backup[vbcol=seagreen]
there's a way to recover
>.
>
|||Hmmm... My problem is that I've never done a backup for that database.
"anonymous@.discussions.microsoft.com" wrote:

> YOu will need to take your full backups and apply the
> trans logs up to the point in time you deleted the table
> and you can then retrieve the records.
> Here's an example from BOL
> -- Restore the database backup.
> RESTORE DATABASE MyNwind
> FROM MyNwind_1, MyNwind_2
> WITH NORECOVERY
> GO
> RESTORE LOG MyNwind
> FROM MyNwind_log1
> WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
> GO
> RESTORE LOG MyNwind
> FROM MyNwind_log2
> WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
> point in time restore,
> message
> 69D4AA671891@.microsoft.com...
> don't have a backup
> there's a way to recover
>
|||Hi,
This will work only if you have the database in FULL recovery model, must
have a FULL database Backup ,
all the subsequent trasnaction log backup files after the full backup.
I feel that in your case you cant revert back with out a backup.
Note:-
Based on the criticality of data please choose a recovery model and define
necessory backup procedures
for your SQL Server databases.
Thanks
Hari
MCDBA
"David" <David@.discussions.microsoft.com> wrote in message
news:EEEAE0E7-BA74-40BF-BC32-840649B457DA@.microsoft.com...[vbcol=seagreen]
> Hmmm... My problem is that I've never done a backup for that database.
>
> "anonymous@.discussions.microsoft.com" wrote:
|||> Hmmm... My problem is that I've never done a backup for that database.
Then you must not consider the data very important!
http://www.aspfaq.com/2449
|||I've never use Lumigent, but they claim to go through the internal free list
(as well as syslogs) to recover what might never be recoverable otherwise.
"David" <David@.discussions.microsoft.com> wrote in message
news:37E4E743-B412-4BF9-BFE2-69D4AA671891@.microsoft.com...
> Hello All,
> I'm need help!
> I have accidently deleted all record from a table. I don't have a backup
at the time I deleted. Could you all tell me if there's a way to recover
those records?
> Thanks.
> David
|||Hi David,
Saw your reply and try download the Log P.I software and this is realyl good.
The web site is www.logpi.com You can restore the deleted transactions, but make sure you follow the steps they have mentioned.
Regards
RK.
"David" wrote:

> Hello All,
> I'm need help!
> I have accidently deleted all record from a table. I don't have a backup at the time I deleted. Could you all tell me if there's a way to recover those records?
> Thanks.
> David

Accidently delete records

Hello All,
I'm need help!
I have accidently deleted all record from a table. I don't have a backup at
the time I deleted. Could you all tell me if there's a way to recover those
records?
Thanks.
DavidYou may be able to use your transaction logs to do a point in time restore,
I'm not sure, but there is hope.
"David" <David@.discussions.microsoft.com> wrote in message
news:37E4E743-B412-4BF9-BFE2-69D4AA671891@.microsoft.com...
> Hello All,
> I'm need help!
> I have accidently deleted all record from a table. I don't have a backup
at the time I deleted. Could you all tell me if there's a way to recover
those records?
> Thanks.
> David|||Lyle,
How do I do that? Could you please share some hint?
"Lyle Spencer" wrote:

> You may be able to use your transaction logs to do a point in time restore
,
> I'm not sure, but there is hope.
> "David" <David@.discussions.microsoft.com> wrote in message
> news:37E4E743-B412-4BF9-BFE2-69D4AA671891@.microsoft.com...
> at the time I deleted. Could you all tell me if there's a way to recover
> those records?
>
>|||YOu will need to take your full backups and apply the
trans logs up to the point in time you deleted the table
and you can then retrieve the records.
Here's an example from BOL
-- Restore the database backup.
RESTORE DATABASE MyNwind
FROM MyNwind_1, MyNwind_2
WITH NORECOVERY
GO
RESTORE LOG MyNwind
FROM MyNwind_log1
WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
GO
RESTORE LOG MyNwind
FROM MyNwind_log2
WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'

>--Original Message--
>Lyle,
>How do I do that? Could you please share some hint?
>
>"Lyle Spencer" wrote:
>
point in time restore,[vbcol=seagreen]
message[vbcol=seagreen]
69D4AA671891@.microsoft.com...[vbcol=seagreen]
don't have a backup[vbcol=seagreen]
there's a way to recover[vbcol=seagreen]
>.
>|||Hmmm... My problem is that I've never done a backup for that database.
"anonymous@.discussions.microsoft.com" wrote:

> YOu will need to take your full backups and apply the
> trans logs up to the point in time you deleted the table
> and you can then retrieve the records.
> Here's an example from BOL
> -- Restore the database backup.
> RESTORE DATABASE MyNwind
> FROM MyNwind_1, MyNwind_2
> WITH NORECOVERY
> GO
> RESTORE LOG MyNwind
> FROM MyNwind_log1
> WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
> GO
> RESTORE LOG MyNwind
> FROM MyNwind_log2
> WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
>
> point in time restore,
> message
> 69D4AA671891@.microsoft.com...
> don't have a backup
> there's a way to recover
>|||Hi,
This will work only if you have the database in FULL recovery model, must
have a FULL database Backup ,
all the subsequent trasnaction log backup files after the full backup.
I feel that in your case you cant revert back with out a backup.
Note:-
Based on the criticality of data please choose a recovery model and define
necessory backup procedures
for your SQL Server databases.
Thanks
Hari
MCDBA
"David" <David@.discussions.microsoft.com> wrote in message
news:EEEAE0E7-BA74-40BF-BC32-840649B457DA@.microsoft.com...[vbcol=seagreen]
> Hmmm... My problem is that I've never done a backup for that database.
>
> "anonymous@.discussions.microsoft.com" wrote:
>|||> Hmmm... My problem is that I've never done a backup for that database.
Then you must not consider the data very important!
http://www.aspfaq.com/2449|||I've never use Lumigent, but they claim to go through the internal free list
(as well as syslogs) to recover what might never be recoverable otherwise.
"David" <David@.discussions.microsoft.com> wrote in message
news:37E4E743-B412-4BF9-BFE2-69D4AA671891@.microsoft.com...
> Hello All,
> I'm need help!
> I have accidently deleted all record from a table. I don't have a backup
at the time I deleted. Could you all tell me if there's a way to recover
those records?
> Thanks.
> David|||Hi David,
Saw your reply and try download the Log P.I software and this is realyl good
.
The web site is www.logpi.com You can restore the deleted transactions, but
make sure you follow the steps they have mentioned.
Regards
RK.
"David" wrote:

> Hello All,
> I'm need help!
> I have accidently deleted all record from a table. I don't have a backup a
t the time I deleted. Could you all tell me if there's a way to recover thos
e records?
> Thanks.
> David

Accidently delete records

Hello All,
I'm need help!
I have accidently deleted all record from a table. I don't have a backup at the time I deleted. Could you all tell me if there's a way to recover those records?
Thanks.
DavidYou may be able to use your transaction logs to do a point in time restore,
I'm not sure, but there is hope.
"David" <David@.discussions.microsoft.com> wrote in message
news:37E4E743-B412-4BF9-BFE2-69D4AA671891@.microsoft.com...
> Hello All,
> I'm need help!
> I have accidently deleted all record from a table. I don't have a backup
at the time I deleted. Could you all tell me if there's a way to recover
those records?
> Thanks.
> David|||Lyle,
How do I do that? Could you please share some hint?
"Lyle Spencer" wrote:
> You may be able to use your transaction logs to do a point in time restore,
> I'm not sure, but there is hope.
> "David" <David@.discussions.microsoft.com> wrote in message
> news:37E4E743-B412-4BF9-BFE2-69D4AA671891@.microsoft.com...
> > Hello All,
> >
> > I'm need help!
> > I have accidently deleted all record from a table. I don't have a backup
> at the time I deleted. Could you all tell me if there's a way to recover
> those records?
> >
> > Thanks.
> > David
>
>|||YOu will need to take your full backups and apply the
trans logs up to the point in time you deleted the table
and you can then retrieve the records.
Here's an example from BOL
-- Restore the database backup.
RESTORE DATABASE MyNwind
FROM MyNwind_1, MyNwind_2
WITH NORECOVERY
GO
RESTORE LOG MyNwind
FROM MyNwind_log1
WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
GO
RESTORE LOG MyNwind
FROM MyNwind_log2
WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
>--Original Message--
>Lyle,
>How do I do that? Could you please share some hint?
>
>"Lyle Spencer" wrote:
>> You may be able to use your transaction logs to do a
point in time restore,
>> I'm not sure, but there is hope.
>> "David" <David@.discussions.microsoft.com> wrote in
message
>> news:37E4E743-B412-4BF9-BFE2-
69D4AA671891@.microsoft.com...
>> > Hello All,
>> >
>> > I'm need help!
>> > I have accidently deleted all record from a table. I
don't have a backup
>> at the time I deleted. Could you all tell me if
there's a way to recover
>> those records?
>> >
>> > Thanks.
>> > David
>>
>.
>|||Hmmm... My problem is that I've never done a backup for that database.
"anonymous@.discussions.microsoft.com" wrote:
> YOu will need to take your full backups and apply the
> trans logs up to the point in time you deleted the table
> and you can then retrieve the records.
> Here's an example from BOL
> -- Restore the database backup.
> RESTORE DATABASE MyNwind
> FROM MyNwind_1, MyNwind_2
> WITH NORECOVERY
> GO
> RESTORE LOG MyNwind
> FROM MyNwind_log1
> WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
> GO
> RESTORE LOG MyNwind
> FROM MyNwind_log2
> WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
> >--Original Message--
> >Lyle,
> >
> >How do I do that? Could you please share some hint?
> >
> >
> >"Lyle Spencer" wrote:
> >
> >> You may be able to use your transaction logs to do a
> point in time restore,
> >> I'm not sure, but there is hope.
> >>
> >> "David" <David@.discussions.microsoft.com> wrote in
> message
> >> news:37E4E743-B412-4BF9-BFE2-
> 69D4AA671891@.microsoft.com...
> >> > Hello All,
> >> >
> >> > I'm need help!
> >> > I have accidently deleted all record from a table. I
> don't have a backup
> >> at the time I deleted. Could you all tell me if
> there's a way to recover
> >> those records?
> >> >
> >> > Thanks.
> >> > David
> >>
> >>
> >>
> >.
> >
>|||Hi,
This will work only if you have the database in FULL recovery model, must
have a FULL database Backup ,
all the subsequent trasnaction log backup files after the full backup.
I feel that in your case you cant revert back with out a backup.
Note:-
Based on the criticality of data please choose a recovery model and define
necessory backup procedures
for your SQL Server databases.
Thanks
Hari
MCDBA
"David" <David@.discussions.microsoft.com> wrote in message
news:EEEAE0E7-BA74-40BF-BC32-840649B457DA@.microsoft.com...
> Hmmm... My problem is that I've never done a backup for that database.
>
> "anonymous@.discussions.microsoft.com" wrote:
> > YOu will need to take your full backups and apply the
> > trans logs up to the point in time you deleted the table
> > and you can then retrieve the records.
> >
> > Here's an example from BOL
> > -- Restore the database backup.
> > RESTORE DATABASE MyNwind
> > FROM MyNwind_1, MyNwind_2
> > WITH NORECOVERY
> > GO
> > RESTORE LOG MyNwind
> > FROM MyNwind_log1
> > WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
> > GO
> > RESTORE LOG MyNwind
> > FROM MyNwind_log2
> > WITH RECOVERY, STOPAT = 'Jul 1, 1998 10:00 AM'
> >
> > >--Original Message--
> > >Lyle,
> > >
> > >How do I do that? Could you please share some hint?
> > >
> > >
> > >"Lyle Spencer" wrote:
> > >
> > >> You may be able to use your transaction logs to do a
> > point in time restore,
> > >> I'm not sure, but there is hope.
> > >>
> > >> "David" <David@.discussions.microsoft.com> wrote in
> > message
> > >> news:37E4E743-B412-4BF9-BFE2-
> > 69D4AA671891@.microsoft.com...
> > >> > Hello All,
> > >> >
> > >> > I'm need help!
> > >> > I have accidently deleted all record from a table. I
> > don't have a backup
> > >> at the time I deleted. Could you all tell me if
> > there's a way to recover
> > >> those records?
> > >> >
> > >> > Thanks.
> > >> > David
> > >>
> > >>
> > >>
> > >.
> > >
> >|||> Hmmm... My problem is that I've never done a backup for that database.
Then you must not consider the data very important!
http://www.aspfaq.com/2449|||I've never use Lumigent, but they claim to go through the internal free list
(as well as syslogs) to recover what might never be recoverable otherwise.
"David" <David@.discussions.microsoft.com> wrote in message
news:37E4E743-B412-4BF9-BFE2-69D4AA671891@.microsoft.com...
> Hello All,
> I'm need help!
> I have accidently deleted all record from a table. I don't have a backup
at the time I deleted. Could you all tell me if there's a way to recover
those records?
> Thanks.
> David

accidentally deleted BUILTIN\Administrators group in Security tab

How can I recreate the BUILTIN\Administrators group that I had deleted
accidentally? My Slqserver 2K is in mixed mode.
Thanks
BillU don't have to as long as sql service and sql agent accounts have appropriate rights however you can do this fform EM --> logins and just add the user Builtin\Administrators

accidentally deleted BUILTIN\Administrators group in Security tab

How can I recreate the BUILTIN\Administrators group that I had deleted
accidentally? My Slqserver 2K is in mixed mode.
Thanks
BillU don't have to as long as sql service and sql agent accounts have appropria
te rights however you can do this fform EM --> logins and just add the user
Builtin\Administrators

accidentally deleted a table in my local SQL Server how can I get back the table

Hi,

I accidentally deleted a table in my local server. How can I get back the table? I did not do it as a transaction!

Thanks in AdvanceYou need to restore back from your backup if available. There may be third party softwares that allow you to do such operations ...