I want to ask one question regarding copying the full backup, differential
and then log into another machine and
restore automatically but I want to know about the recovery mode I have to
set on that machine so that only read
and restoration can be take place and Yes I don't want to create the
disaster recovery plan.
Can anyone add his/her comments.
Thanks
Hi,
Recovery model will not really matter since you are going to keep the
database in READ_ONLY mode. See the below command
to set the database to READ ONLY mode.
ALTER DATABASE <DBNAME> SET READ_ONLY
Thanks
Hari
SQL Server MVP
"Rogers" <Rogers@.discussions.microsoft.com> wrote in message
news:ACC08DB9-FCA1-4EB8-AFD2-4DAFB3D2BE98@.microsoft.com...
>I want to ask one question regarding copying the full backup, differential
> and then log into another machine and
> restore automatically but I want to know about the recovery mode I have to
> set on that machine so that only read
> and restoration can be take place and Yes I don't want to create the
> disaster recovery plan.
> Can anyone add his/her comments.
> Thanks
|||So, in the read only mode we can restore the database right...
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uYv$sqDPFHA.2748@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Hi,
> Recovery model will not really matter since you are going to keep the
> database in READ_ONLY mode. See the below command
> to set the database to READ ONLY mode.
> ALTER DATABASE <DBNAME> SET READ_ONLY
> Thanks
> Hari
> SQL Server MVP
>
> "Rogers" <Rogers@.discussions.microsoft.com> wrote in message
> news:ACC08DB9-FCA1-4EB8-AFD2-4DAFB3D2BE98@.microsoft.com...
differential[vbcol=seagreen]
to
>
|||Hi John,
Yes, But while restoring you must use STANDBY (undo file name) file name in
RESTORE DATABASE and RESTORE LOG command.
eg:-
RESTORE DATABASE TESTDB FROM DISK='d:\backup.bak' with
standy='d:\stanby.fil'
After this you could start restoring the Transaction logs based on a
frequency. To load the transaction logs you could use the below command
RESTORE LOG TESTDB FROM DISK='d:\backuplog.bak' with standy='d:\stanby.fil'
Thanks
Hari
SQL Server MVP
"John" <naissani@.hotmail.com> wrote in message
news:uCaXLEMPFHA.1096@.tk2msftngp13.phx.gbl...
> So, in the read only mode we can restore the database right...
> "Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
> news:uYv$sqDPFHA.2748@.TK2MSFTNGP09.phx.gbl...
> differential
> to
>
sql
Showing posts with label machine. Show all posts
Showing posts with label machine. Show all posts
Wednesday, March 28, 2012
Monday, March 26, 2012
recovery db from files *.mdf and *.ldf
Hi
My server machine had problems, and i had that reinstall,=20
and I only can recover the files *.mdf, and *.ldf.
I tried to recover the one db with the command:
EXEC sp_attach_db @.dbname =3D'viaticos',=20
@.filename1 =3D 'F:\Microsoft SQL=20
Server\MSSQL\Data\Viaticos_Data.mdf',=20
@.filename2 =3D 'F:\Microsoft SQL=20
Server\MSSQL\Data\Viaticos_log.ldf'
and=20
EXEC sp_attach_single_file_db 'viaticos', @.physname=20
=3D 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.MDF'
But, the last commnad can create the db, and generated the=20
follow error;=20
Error de activaci=F3n de dispositivo. El nombre de archivo=20
f=EDsico 'f:\Microsoft
SQL Server\MSSQL\data\Viaticos_Log.LDF' puede ser=20
incorrecto.
Se cre=F3 un nuevo archivo de registro llamado 'F:\Microsoft=20
SQL
Server\MSSQL\Data\viaticos_log.LDF'.
With this option I can see the store procedure and views,=20
but i don't see the data and definitions of tables, and
generated this error:
SQL-DMO(ODBC SQLState:08S01
Error 0: this server has been disconected. You must=20
reconnected to perform this operation
Error 823.
and=20
Error 22528[SQL-DMO] This server connect has been=20
unexpected broken and cannot be reconected.
How I do for recover the data and structure of tables?
than's.
Do you not have proper backups?
You could *try* sp_attach_single_file_db against just the MDF file, but if
SQL Server crashed and it wasn't detached correctly, I'm not very
optimistic.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Ivan Alexander Laverde G" <anonymous@.discussions.microsoft.com> wrote in
message news:fe6101c43ea3$ee330950$a501280a@.phx.gbl...
Hi
My server machine had problems, and i had that reinstall,
and I only can recover the files *.mdf, and *.ldf.
I tried to recover the one db with the command:
EXEC sp_attach_db @.dbname ='viaticos',
@.filename1 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.mdf',
@.filename2 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_log.ldf'
and
EXEC sp_attach_single_file_db 'viaticos', @.physname
= 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.MDF'
But, the last commnad can create the db, and generated the
follow error;
Error de activacin de dispositivo. El nombre de archivo
fsico 'f:\Microsoft
SQL Server\MSSQL\data\Viaticos_Log.LDF' puede ser
incorrecto.
Se cre un nuevo archivo de registro llamado 'F:\Microsoft
SQL
Server\MSSQL\Data\viaticos_log.LDF'.
With this option I can see the store procedure and views,
but i don't see the data and definitions of tables, and
generated this error:
SQL-DMO(ODBC SQLState:08S01
Error 0: this server has been disconected. You must
reconnected to perform this operation
Error 823.
and
Error 22528[SQL-DMO] This server connect has been
unexpected broken and cannot be reconected.
How I do for recover the data and structure of tables?
than's.
|||Hi ,
Try the below steps, it might work if you are lucky.
1. Create a new database with the same name
2. Mention the file names (MDF and LDF ) same as old but in different
3. After you create the new database, stop SQL Server
4. Copy the old database files (MDF and LDF) over the top of the new ones.
5 SQL Server will recognize the database.
6. Database will started in suspect status
7. Update the database status to emergency mode (use below script in Query
Analyzer)
Sp_configure "allow updates", 1
go
Reconfigure with override
GO
Update sysdatabases set status = 32768 where name = "BadDbName"
go
Sp_configure "allow updates", 0
go
Reconfigure with override
GO
8. Now the database will be open for read only (with out using Transaction
log)
9. Create a new database and use DTS to move the data and objects from old
database to new database
Note:
After step-7 try DBCC Checkdb with repair options (See books online) and see
if it can be repaired.
Thanks
Hari
MCDBA
"Ivan Alexander Laverde G" <anonymous@.discussions.microsoft.com> wrote in
message news:fe6101c43ea3$ee330950$a501280a@.phx.gbl...
Hi
My server machine had problems, and i had that reinstall,
and I only can recover the files *.mdf, and *.ldf.
I tried to recover the one db with the command:
EXEC sp_attach_db @.dbname ='viaticos',
@.filename1 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.mdf',
@.filename2 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_log.ldf'
and
EXEC sp_attach_single_file_db 'viaticos', @.physname
= 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.MDF'
But, the last commnad can create the db, and generated the
follow error;
Error de activacin de dispositivo. El nombre de archivo
fsico 'f:\Microsoft
SQL Server\MSSQL\data\Viaticos_Log.LDF' puede ser
incorrecto.
Se cre un nuevo archivo de registro llamado 'F:\Microsoft
SQL
Server\MSSQL\Data\viaticos_log.LDF'.
With this option I can see the store procedure and views,
but i don't see the data and definitions of tables, and
generated this error:
SQL-DMO(ODBC SQLState:08S01
Error 0: this server has been disconected. You must
reconnected to perform this operation
Error 823.
and
Error 22528[SQL-DMO] This server connect has been
unexpected broken and cannot be reconected.
How I do for recover the data and structure of tables?
than's.
My server machine had problems, and i had that reinstall,=20
and I only can recover the files *.mdf, and *.ldf.
I tried to recover the one db with the command:
EXEC sp_attach_db @.dbname =3D'viaticos',=20
@.filename1 =3D 'F:\Microsoft SQL=20
Server\MSSQL\Data\Viaticos_Data.mdf',=20
@.filename2 =3D 'F:\Microsoft SQL=20
Server\MSSQL\Data\Viaticos_log.ldf'
and=20
EXEC sp_attach_single_file_db 'viaticos', @.physname=20
=3D 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.MDF'
But, the last commnad can create the db, and generated the=20
follow error;=20
Error de activaci=F3n de dispositivo. El nombre de archivo=20
f=EDsico 'f:\Microsoft
SQL Server\MSSQL\data\Viaticos_Log.LDF' puede ser=20
incorrecto.
Se cre=F3 un nuevo archivo de registro llamado 'F:\Microsoft=20
SQL
Server\MSSQL\Data\viaticos_log.LDF'.
With this option I can see the store procedure and views,=20
but i don't see the data and definitions of tables, and
generated this error:
SQL-DMO(ODBC SQLState:08S01
Error 0: this server has been disconected. You must=20
reconnected to perform this operation
Error 823.
and=20
Error 22528[SQL-DMO] This server connect has been=20
unexpected broken and cannot be reconected.
How I do for recover the data and structure of tables?
than's.
Do you not have proper backups?
You could *try* sp_attach_single_file_db against just the MDF file, but if
SQL Server crashed and it wasn't detached correctly, I'm not very
optimistic.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Ivan Alexander Laverde G" <anonymous@.discussions.microsoft.com> wrote in
message news:fe6101c43ea3$ee330950$a501280a@.phx.gbl...
Hi
My server machine had problems, and i had that reinstall,
and I only can recover the files *.mdf, and *.ldf.
I tried to recover the one db with the command:
EXEC sp_attach_db @.dbname ='viaticos',
@.filename1 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.mdf',
@.filename2 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_log.ldf'
and
EXEC sp_attach_single_file_db 'viaticos', @.physname
= 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.MDF'
But, the last commnad can create the db, and generated the
follow error;
Error de activacin de dispositivo. El nombre de archivo
fsico 'f:\Microsoft
SQL Server\MSSQL\data\Viaticos_Log.LDF' puede ser
incorrecto.
Se cre un nuevo archivo de registro llamado 'F:\Microsoft
SQL
Server\MSSQL\Data\viaticos_log.LDF'.
With this option I can see the store procedure and views,
but i don't see the data and definitions of tables, and
generated this error:
SQL-DMO(ODBC SQLState:08S01
Error 0: this server has been disconected. You must
reconnected to perform this operation
Error 823.
and
Error 22528[SQL-DMO] This server connect has been
unexpected broken and cannot be reconected.
How I do for recover the data and structure of tables?
than's.
|||Hi ,
Try the below steps, it might work if you are lucky.
1. Create a new database with the same name
2. Mention the file names (MDF and LDF ) same as old but in different
3. After you create the new database, stop SQL Server
4. Copy the old database files (MDF and LDF) over the top of the new ones.
5 SQL Server will recognize the database.
6. Database will started in suspect status
7. Update the database status to emergency mode (use below script in Query
Analyzer)
Sp_configure "allow updates", 1
go
Reconfigure with override
GO
Update sysdatabases set status = 32768 where name = "BadDbName"
go
Sp_configure "allow updates", 0
go
Reconfigure with override
GO
8. Now the database will be open for read only (with out using Transaction
log)
9. Create a new database and use DTS to move the data and objects from old
database to new database
Note:
After step-7 try DBCC Checkdb with repair options (See books online) and see
if it can be repaired.
Thanks
Hari
MCDBA
"Ivan Alexander Laverde G" <anonymous@.discussions.microsoft.com> wrote in
message news:fe6101c43ea3$ee330950$a501280a@.phx.gbl...
Hi
My server machine had problems, and i had that reinstall,
and I only can recover the files *.mdf, and *.ldf.
I tried to recover the one db with the command:
EXEC sp_attach_db @.dbname ='viaticos',
@.filename1 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.mdf',
@.filename2 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_log.ldf'
and
EXEC sp_attach_single_file_db 'viaticos', @.physname
= 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.MDF'
But, the last commnad can create the db, and generated the
follow error;
Error de activacin de dispositivo. El nombre de archivo
fsico 'f:\Microsoft
SQL Server\MSSQL\data\Viaticos_Log.LDF' puede ser
incorrecto.
Se cre un nuevo archivo de registro llamado 'F:\Microsoft
SQL
Server\MSSQL\Data\viaticos_log.LDF'.
With this option I can see the store procedure and views,
but i don't see the data and definitions of tables, and
generated this error:
SQL-DMO(ODBC SQLState:08S01
Error 0: this server has been disconected. You must
reconnected to perform this operation
Error 823.
and
Error 22528[SQL-DMO] This server connect has been
unexpected broken and cannot be reconected.
How I do for recover the data and structure of tables?
than's.
recovery db from files *.mdf and *.ldf
Hi
My server machine had problems, and i had that reinstall,=20
and I only can recover the files *.mdf, and *.ldf.
I tried to recover the one db with the command:
EXEC sp_attach_db @.dbname =3D'viaticos',=20
@.filename1 =3D 'F:\Microsoft SQL=20
Server\MSSQL\Data\Viaticos_Data.mdf',=20
@.filename2 =3D 'F:\Microsoft SQL=20
Server\MSSQL\Data\Viaticos_log.ldf'
and=20
EXEC sp_attach_single_file_db 'viaticos', @.physname=20
=3D 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.MDF'
But, the last commnad can create the db, and generated the=20
follow error;=20
Error de activaci=F3n de dispositivo. El nombre de archivo=20
f=EDsico 'f:\Microsoft
SQL Server\MSSQL\data\Viaticos_Log.LDF' puede ser=20
incorrecto.
Se cre=F3 un nuevo archivo de registro llamado 'F:\Microsoft=20
SQL
Server\MSSQL\Data\viaticos_log.LDF'.
With this option I can see the store procedure and views,=20
but i don't see the data and definitions of tables, and
generated this error:
SQL-DMO(ODBC SQLState:08S01
Error 0: this server has been disconected. You must=20
reconnected to perform this operation
Error 823.
and=20
Error 22528[SQL-DMO] This server connect has been=20
unexpected broken and cannot be reconected.
How I do for recover the data and structure of tables?
than's.Do you not have proper backups?
You could *try* sp_attach_single_file_db against just the MDF file, but if
SQL Server crashed and it wasn't detached correctly, I'm not very
optimistic.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Ivan Alexander Laverde G" <anonymous@.discussions.microsoft.com> wrote in
message news:fe6101c43ea3$ee330950$a501280a@.phx.gbl...
Hi
My server machine had problems, and i had that reinstall,
and I only can recover the files *.mdf, and *.ldf.
I tried to recover the one db with the command:
EXEC sp_attach_db @.dbname ='viaticos',
@.filename1 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.mdf',
@.filename2 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_log.ldf'
and
EXEC sp_attach_single_file_db 'viaticos', @.physname
= 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.MDF'
But, the last commnad can create the db, and generated the
follow error;
Error de activacin de dispositivo. El nombre de archivo
fsico 'f:\Microsoft
SQL Server\MSSQL\data\Viaticos_Log.LDF' puede ser
incorrecto.
Se cre un nuevo archivo de registro llamado 'F:\Microsoft
SQL
Server\MSSQL\Data\viaticos_log.LDF'.
With this option I can see the store procedure and views,
but i don't see the data and definitions of tables, and
generated this error:
SQL-DMO(ODBC SQLState:08S01
Error 0: this server has been disconected. You must
reconnected to perform this operation
Error 823.
and
Error 22528[SQL-DMO] This server connect has been
unexpected broken and cannot be reconected.
How I do for recover the data and structure of tables?
than's.|||Hi ,
Try the below steps, it might work if you are lucky.
1. Create a new database with the same name
2. Mention the file names (MDF and LDF ) same as old but in different
3. After you create the new database, stop SQL Server
4. Copy the old database files (MDF and LDF) over the top of the new ones.
5 SQL Server will recognize the database.
6. Database will started in suspect status
7. Update the database status to emergency mode (use below script in Query
Analyzer)
Sp_configure "allow updates", 1
go
Reconfigure with override
GO
Update sysdatabases set status = 32768 where name = "BadDbName"
go
Sp_configure "allow updates", 0
go
Reconfigure with override
GO
8. Now the database will be open for read only (with out using Transaction
log)
9. Create a new database and use DTS to move the data and objects from old
database to new database
Note:
After step-7 try DBCC Checkdb with repair options (See books online) and see
if it can be repaired.
Thanks
Hari
MCDBA
"Ivan Alexander Laverde G" <anonymous@.discussions.microsoft.com> wrote in
message news:fe6101c43ea3$ee330950$a501280a@.phx.gbl...
Hi
My server machine had problems, and i had that reinstall,
and I only can recover the files *.mdf, and *.ldf.
I tried to recover the one db with the command:
EXEC sp_attach_db @.dbname ='viaticos',
@.filename1 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.mdf',
@.filename2 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_log.ldf'
and
EXEC sp_attach_single_file_db 'viaticos', @.physname
= 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.MDF'
But, the last commnad can create the db, and generated the
follow error;
Error de activacin de dispositivo. El nombre de archivo
fsico 'f:\Microsoft
SQL Server\MSSQL\data\Viaticos_Log.LDF' puede ser
incorrecto.
Se cre un nuevo archivo de registro llamado 'F:\Microsoft
SQL
Server\MSSQL\Data\viaticos_log.LDF'.
With this option I can see the store procedure and views,
but i don't see the data and definitions of tables, and
generated this error:
SQL-DMO(ODBC SQLState:08S01
Error 0: this server has been disconected. You must
reconnected to perform this operation
Error 823.
and
Error 22528[SQL-DMO] This server connect has been
unexpected broken and cannot be reconected.
How I do for recover the data and structure of tables?
than's.
My server machine had problems, and i had that reinstall,=20
and I only can recover the files *.mdf, and *.ldf.
I tried to recover the one db with the command:
EXEC sp_attach_db @.dbname =3D'viaticos',=20
@.filename1 =3D 'F:\Microsoft SQL=20
Server\MSSQL\Data\Viaticos_Data.mdf',=20
@.filename2 =3D 'F:\Microsoft SQL=20
Server\MSSQL\Data\Viaticos_log.ldf'
and=20
EXEC sp_attach_single_file_db 'viaticos', @.physname=20
=3D 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.MDF'
But, the last commnad can create the db, and generated the=20
follow error;=20
Error de activaci=F3n de dispositivo. El nombre de archivo=20
f=EDsico 'f:\Microsoft
SQL Server\MSSQL\data\Viaticos_Log.LDF' puede ser=20
incorrecto.
Se cre=F3 un nuevo archivo de registro llamado 'F:\Microsoft=20
SQL
Server\MSSQL\Data\viaticos_log.LDF'.
With this option I can see the store procedure and views,=20
but i don't see the data and definitions of tables, and
generated this error:
SQL-DMO(ODBC SQLState:08S01
Error 0: this server has been disconected. You must=20
reconnected to perform this operation
Error 823.
and=20
Error 22528[SQL-DMO] This server connect has been=20
unexpected broken and cannot be reconected.
How I do for recover the data and structure of tables?
than's.Do you not have proper backups?
You could *try* sp_attach_single_file_db against just the MDF file, but if
SQL Server crashed and it wasn't detached correctly, I'm not very
optimistic.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Ivan Alexander Laverde G" <anonymous@.discussions.microsoft.com> wrote in
message news:fe6101c43ea3$ee330950$a501280a@.phx.gbl...
Hi
My server machine had problems, and i had that reinstall,
and I only can recover the files *.mdf, and *.ldf.
I tried to recover the one db with the command:
EXEC sp_attach_db @.dbname ='viaticos',
@.filename1 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.mdf',
@.filename2 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_log.ldf'
and
EXEC sp_attach_single_file_db 'viaticos', @.physname
= 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.MDF'
But, the last commnad can create the db, and generated the
follow error;
Error de activacin de dispositivo. El nombre de archivo
fsico 'f:\Microsoft
SQL Server\MSSQL\data\Viaticos_Log.LDF' puede ser
incorrecto.
Se cre un nuevo archivo de registro llamado 'F:\Microsoft
SQL
Server\MSSQL\Data\viaticos_log.LDF'.
With this option I can see the store procedure and views,
but i don't see the data and definitions of tables, and
generated this error:
SQL-DMO(ODBC SQLState:08S01
Error 0: this server has been disconected. You must
reconnected to perform this operation
Error 823.
and
Error 22528[SQL-DMO] This server connect has been
unexpected broken and cannot be reconected.
How I do for recover the data and structure of tables?
than's.|||Hi ,
Try the below steps, it might work if you are lucky.
1. Create a new database with the same name
2. Mention the file names (MDF and LDF ) same as old but in different
3. After you create the new database, stop SQL Server
4. Copy the old database files (MDF and LDF) over the top of the new ones.
5 SQL Server will recognize the database.
6. Database will started in suspect status
7. Update the database status to emergency mode (use below script in Query
Analyzer)
Sp_configure "allow updates", 1
go
Reconfigure with override
GO
Update sysdatabases set status = 32768 where name = "BadDbName"
go
Sp_configure "allow updates", 0
go
Reconfigure with override
GO
8. Now the database will be open for read only (with out using Transaction
log)
9. Create a new database and use DTS to move the data and objects from old
database to new database
Note:
After step-7 try DBCC Checkdb with repair options (See books online) and see
if it can be repaired.
Thanks
Hari
MCDBA
"Ivan Alexander Laverde G" <anonymous@.discussions.microsoft.com> wrote in
message news:fe6101c43ea3$ee330950$a501280a@.phx.gbl...
Hi
My server machine had problems, and i had that reinstall,
and I only can recover the files *.mdf, and *.ldf.
I tried to recover the one db with the command:
EXEC sp_attach_db @.dbname ='viaticos',
@.filename1 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.mdf',
@.filename2 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_log.ldf'
and
EXEC sp_attach_single_file_db 'viaticos', @.physname
= 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.MDF'
But, the last commnad can create the db, and generated the
follow error;
Error de activacin de dispositivo. El nombre de archivo
fsico 'f:\Microsoft
SQL Server\MSSQL\data\Viaticos_Log.LDF' puede ser
incorrecto.
Se cre un nuevo archivo de registro llamado 'F:\Microsoft
SQL
Server\MSSQL\Data\viaticos_log.LDF'.
With this option I can see the store procedure and views,
but i don't see the data and definitions of tables, and
generated this error:
SQL-DMO(ODBC SQLState:08S01
Error 0: this server has been disconected. You must
reconnected to perform this operation
Error 823.
and
Error 22528[SQL-DMO] This server connect has been
unexpected broken and cannot be reconected.
How I do for recover the data and structure of tables?
than's.
recovery db from files *.mdf and *.ldf
Hi
My server machine had problems, and i had that reinstall, and I only can recover the files *.mdf, and *.ldf.
I tried to recover the one db with the command:
EXEC sp_attach_db @.dbname =3D'viaticos', @.filename1 =3D 'F:\Microsoft SQL Server\MSSQL\Data\Viaticos_Data.mdf', @.filename2 =3D 'F:\Microsoft SQL Server\MSSQL\Data\Viaticos_log.ldf'
and
EXEC sp_attach_single_file_db 'viaticos', @.physname =3D 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.MDF'
But, the last commnad can create the db, and generated the follow error;
Error de activaci=F3n de dispositivo. El nombre de archivo f=EDsico 'f:\Microsoft
SQL Server\MSSQL\data\Viaticos_Log.LDF' puede ser incorrecto.
Se cre=F3 un nuevo archivo de registro llamado 'F:\Microsoft SQL
Server\MSSQL\Data\viaticos_log.LDF'.
With this option I can see the store procedure and views, but i don't see the data and definitions of tables, and
generated this error:
SQL-DMO(ODBC SQLState:08S01
Error 0: this server has been disconected. You must reconnected to perform this operation
Error 823.
and
Error 22528[SQL-DMO] This server connect has been unexpected broken and cannot be reconected.
How I do for recover the data and structure of tables?
than's.Do you not have proper backups?
You could *try* sp_attach_single_file_db against just the MDF file, but if
SQL Server crashed and it wasn't detached correctly, I'm not very
optimistic.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Ivan Alexander Laverde G" <anonymous@.discussions.microsoft.com> wrote in
message news:fe6101c43ea3$ee330950$a501280a@.phx.gbl...
Hi
My server machine had problems, and i had that reinstall,
and I only can recover the files *.mdf, and *.ldf.
I tried to recover the one db with the command:
EXEC sp_attach_db @.dbname ='viaticos',
@.filename1 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.mdf',
@.filename2 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_log.ldf'
and
EXEC sp_attach_single_file_db 'viaticos', @.physname
= 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.MDF'
But, the last commnad can create the db, and generated the
follow error;
Error de activación de dispositivo. El nombre de archivo
físico 'f:\Microsoft
SQL Server\MSSQL\data\Viaticos_Log.LDF' puede ser
incorrecto.
Se creó un nuevo archivo de registro llamado 'F:\Microsoft
SQL
Server\MSSQL\Data\viaticos_log.LDF'.
With this option I can see the store procedure and views,
but i don't see the data and definitions of tables, and
generated this error:
SQL-DMO(ODBC SQLState:08S01
Error 0: this server has been disconected. You must
reconnected to perform this operation
Error 823.
and
Error 22528[SQL-DMO] This server connect has been
unexpected broken and cannot be reconected.
How I do for recover the data and structure of tables?
than's.|||Hi ,
Try the below steps, it might work if you are lucky.
1. Create a new database with the same name
2. Mention the file names (MDF and LDF ) same as old but in different
3. After you create the new database, stop SQL Server
4. Copy the old database files (MDF and LDF) over the top of the new ones.
5 SQL Server will recognize the database.
6. Database will started in suspect status
7. Update the database status to emergency mode (use below script in Query
Analyzer)
Sp_configure "allow updates", 1
go
Reconfigure with override
GO
Update sysdatabases set status = 32768 where name = "BadDbName"
go
Sp_configure "allow updates", 0
go
Reconfigure with override
GO
8. Now the database will be open for read only (with out using Transaction
log)
9. Create a new database and use DTS to move the data and objects from old
database to new database
Note:
After step-7 try DBCC Checkdb with repair options (See books online) and see
if it can be repaired.
Thanks
Hari
MCDBA
"Ivan Alexander Laverde G" <anonymous@.discussions.microsoft.com> wrote in
message news:fe6101c43ea3$ee330950$a501280a@.phx.gbl...
Hi
My server machine had problems, and i had that reinstall,
and I only can recover the files *.mdf, and *.ldf.
I tried to recover the one db with the command:
EXEC sp_attach_db @.dbname ='viaticos',
@.filename1 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.mdf',
@.filename2 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_log.ldf'
and
EXEC sp_attach_single_file_db 'viaticos', @.physname
= 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.MDF'
But, the last commnad can create the db, and generated the
follow error;
Error de activación de dispositivo. El nombre de archivo
físico 'f:\Microsoft
SQL Server\MSSQL\data\Viaticos_Log.LDF' puede ser
incorrecto.
Se creó un nuevo archivo de registro llamado 'F:\Microsoft
SQL
Server\MSSQL\Data\viaticos_log.LDF'.
With this option I can see the store procedure and views,
but i don't see the data and definitions of tables, and
generated this error:
SQL-DMO(ODBC SQLState:08S01
Error 0: this server has been disconected. You must
reconnected to perform this operation
Error 823.
and
Error 22528[SQL-DMO] This server connect has been
unexpected broken and cannot be reconected.
How I do for recover the data and structure of tables?
than's.sql
My server machine had problems, and i had that reinstall, and I only can recover the files *.mdf, and *.ldf.
I tried to recover the one db with the command:
EXEC sp_attach_db @.dbname =3D'viaticos', @.filename1 =3D 'F:\Microsoft SQL Server\MSSQL\Data\Viaticos_Data.mdf', @.filename2 =3D 'F:\Microsoft SQL Server\MSSQL\Data\Viaticos_log.ldf'
and
EXEC sp_attach_single_file_db 'viaticos', @.physname =3D 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.MDF'
But, the last commnad can create the db, and generated the follow error;
Error de activaci=F3n de dispositivo. El nombre de archivo f=EDsico 'f:\Microsoft
SQL Server\MSSQL\data\Viaticos_Log.LDF' puede ser incorrecto.
Se cre=F3 un nuevo archivo de registro llamado 'F:\Microsoft SQL
Server\MSSQL\Data\viaticos_log.LDF'.
With this option I can see the store procedure and views, but i don't see the data and definitions of tables, and
generated this error:
SQL-DMO(ODBC SQLState:08S01
Error 0: this server has been disconected. You must reconnected to perform this operation
Error 823.
and
Error 22528[SQL-DMO] This server connect has been unexpected broken and cannot be reconected.
How I do for recover the data and structure of tables?
than's.Do you not have proper backups?
You could *try* sp_attach_single_file_db against just the MDF file, but if
SQL Server crashed and it wasn't detached correctly, I'm not very
optimistic.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Ivan Alexander Laverde G" <anonymous@.discussions.microsoft.com> wrote in
message news:fe6101c43ea3$ee330950$a501280a@.phx.gbl...
Hi
My server machine had problems, and i had that reinstall,
and I only can recover the files *.mdf, and *.ldf.
I tried to recover the one db with the command:
EXEC sp_attach_db @.dbname ='viaticos',
@.filename1 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.mdf',
@.filename2 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_log.ldf'
and
EXEC sp_attach_single_file_db 'viaticos', @.physname
= 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.MDF'
But, the last commnad can create the db, and generated the
follow error;
Error de activación de dispositivo. El nombre de archivo
físico 'f:\Microsoft
SQL Server\MSSQL\data\Viaticos_Log.LDF' puede ser
incorrecto.
Se creó un nuevo archivo de registro llamado 'F:\Microsoft
SQL
Server\MSSQL\Data\viaticos_log.LDF'.
With this option I can see the store procedure and views,
but i don't see the data and definitions of tables, and
generated this error:
SQL-DMO(ODBC SQLState:08S01
Error 0: this server has been disconected. You must
reconnected to perform this operation
Error 823.
and
Error 22528[SQL-DMO] This server connect has been
unexpected broken and cannot be reconected.
How I do for recover the data and structure of tables?
than's.|||Hi ,
Try the below steps, it might work if you are lucky.
1. Create a new database with the same name
2. Mention the file names (MDF and LDF ) same as old but in different
3. After you create the new database, stop SQL Server
4. Copy the old database files (MDF and LDF) over the top of the new ones.
5 SQL Server will recognize the database.
6. Database will started in suspect status
7. Update the database status to emergency mode (use below script in Query
Analyzer)
Sp_configure "allow updates", 1
go
Reconfigure with override
GO
Update sysdatabases set status = 32768 where name = "BadDbName"
go
Sp_configure "allow updates", 0
go
Reconfigure with override
GO
8. Now the database will be open for read only (with out using Transaction
log)
9. Create a new database and use DTS to move the data and objects from old
database to new database
Note:
After step-7 try DBCC Checkdb with repair options (See books online) and see
if it can be repaired.
Thanks
Hari
MCDBA
"Ivan Alexander Laverde G" <anonymous@.discussions.microsoft.com> wrote in
message news:fe6101c43ea3$ee330950$a501280a@.phx.gbl...
Hi
My server machine had problems, and i had that reinstall,
and I only can recover the files *.mdf, and *.ldf.
I tried to recover the one db with the command:
EXEC sp_attach_db @.dbname ='viaticos',
@.filename1 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.mdf',
@.filename2 = 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_log.ldf'
and
EXEC sp_attach_single_file_db 'viaticos', @.physname
= 'F:\Microsoft SQL
Server\MSSQL\Data\Viaticos_Data.MDF'
But, the last commnad can create the db, and generated the
follow error;
Error de activación de dispositivo. El nombre de archivo
físico 'f:\Microsoft
SQL Server\MSSQL\data\Viaticos_Log.LDF' puede ser
incorrecto.
Se creó un nuevo archivo de registro llamado 'F:\Microsoft
SQL
Server\MSSQL\Data\viaticos_log.LDF'.
With this option I can see the store procedure and views,
but i don't see the data and definitions of tables, and
generated this error:
SQL-DMO(ODBC SQLState:08S01
Error 0: this server has been disconected. You must
reconnected to perform this operation
Error 823.
and
Error 22528[SQL-DMO] This server connect has been
unexpected broken and cannot be reconected.
How I do for recover the data and structure of tables?
than's.sql
Recovering SQL server
Hello all,
Last night we had 2 drives die on our test machine. The data (all our
databases)has been regretably lost. My question is;
How can I use the Production box and copy all the databases over to the
newly installed drives? At this point, I am unable to even start the sql
server service. SQL 7 on NT4 both machines.
Any advice on how to recover this nightmare would be appreciated.
Thanks in advance,
Tom
Tom,
Use your backups instead of trying to move the database files. On case you, for some reason, don't want to use
the backups, you can try to copy the mdf, ndf and ldf files that constitutes each database and attach them to
the working SQL Server using sp_attach_db.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> Hello all,
> Last night we had 2 drives die on our test machine. The data (all our
> databases)has been regretably lost. My question is;
> How can I use the Production box and copy all the databases over to the
> newly installed drives? At this point, I am unable to even start the sql
> server service. SQL 7 on NT4 both machines.
> Any advice on how to recover this nightmare would be appreciated.
> Thanks in advance,
> Tom
>
|||Tibor,
Thanks for the fast response, but I think the problem is deeper that that.
I can not even get the instance of SQL server to start. When I try to start
the service I get an NT internal error. Could this be because I lost both
master and msdb databases as well as my user databases? I do have
backups(master,msdb,...), but without having SQL running , I cant restore
them. Any other suggestions?
Thanks for your time.
Tom
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uEzBcW6YEHA.3128@.TK2MSFTNGP09.phx.gbl...
> Tom,
> Use your backups instead of trying to move the database files. On case
you, for some reason, don't want to use
> the backups, you can try to copy the mdf, ndf and ldf files that
constitutes each database and attach them to
> the working SQL Server using sp_attach_db.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message
news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
>
|||Check out the SQL Server errorlog.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message news:ui%23Zs4FZEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Tibor,
> Thanks for the fast response, but I think the problem is deeper that that.
> I can not even get the instance of SQL server to start. When I try to start
> the service I get an NT internal error. Could this be because I lost both
> master and msdb databases as well as my user databases? I do have
> backups(master,msdb,...), but without having SQL running , I cant restore
> them. Any other suggestions?
> Thanks for your time.
> Tom
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uEzBcW6YEHA.3128@.TK2MSFTNGP09.phx.gbl...
> you, for some reason, don't want to use
> constitutes each database and attach them to
> news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
>
Last night we had 2 drives die on our test machine. The data (all our
databases)has been regretably lost. My question is;
How can I use the Production box and copy all the databases over to the
newly installed drives? At this point, I am unable to even start the sql
server service. SQL 7 on NT4 both machines.
Any advice on how to recover this nightmare would be appreciated.
Thanks in advance,
Tom
Tom,
Use your backups instead of trying to move the database files. On case you, for some reason, don't want to use
the backups, you can try to copy the mdf, ndf and ldf files that constitutes each database and attach them to
the working SQL Server using sp_attach_db.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> Hello all,
> Last night we had 2 drives die on our test machine. The data (all our
> databases)has been regretably lost. My question is;
> How can I use the Production box and copy all the databases over to the
> newly installed drives? At this point, I am unable to even start the sql
> server service. SQL 7 on NT4 both machines.
> Any advice on how to recover this nightmare would be appreciated.
> Thanks in advance,
> Tom
>
|||Tibor,
Thanks for the fast response, but I think the problem is deeper that that.
I can not even get the instance of SQL server to start. When I try to start
the service I get an NT internal error. Could this be because I lost both
master and msdb databases as well as my user databases? I do have
backups(master,msdb,...), but without having SQL running , I cant restore
them. Any other suggestions?
Thanks for your time.
Tom
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uEzBcW6YEHA.3128@.TK2MSFTNGP09.phx.gbl...
> Tom,
> Use your backups instead of trying to move the database files. On case
you, for some reason, don't want to use
> the backups, you can try to copy the mdf, ndf and ldf files that
constitutes each database and attach them to
> the working SQL Server using sp_attach_db.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message
news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
>
|||Check out the SQL Server errorlog.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message news:ui%23Zs4FZEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Tibor,
> Thanks for the fast response, but I think the problem is deeper that that.
> I can not even get the instance of SQL server to start. When I try to start
> the service I get an NT internal error. Could this be because I lost both
> master and msdb databases as well as my user databases? I do have
> backups(master,msdb,...), but without having SQL running , I cant restore
> them. Any other suggestions?
> Thanks for your time.
> Tom
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uEzBcW6YEHA.3128@.TK2MSFTNGP09.phx.gbl...
> you, for some reason, don't want to use
> constitutes each database and attach them to
> news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
>
Recovering SQL server
Hello all,
Last night we had 2 drives die on our test machine. The data (all our
databases)has been regretably lost. My question is;
How can I use the Production box and copy all the databases over to the
newly installed drives? At this point, I am unable to even start the sql
server service. SQL 7 on NT4 both machines.
Any advice on how to recover this nightmare would be appreciated.
Thanks in advance,
TomTom,
Use your backups instead of trying to move the database files. On case you,
for some reason, don't want to use
the backups, you can try to copy the mdf, ndf and ldf files that constitutes
each database and attach them to
the working SQL Server using sp_attach_db.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.ph
x.gbl...
> Hello all,
> Last night we had 2 drives die on our test machine. The data (all our
> databases)has been regretably lost. My question is;
> How can I use the Production box and copy all the databases over to the
> newly installed drives? At this point, I am unable to even start the sql
> server service. SQL 7 on NT4 both machines.
> Any advice on how to recover this nightmare would be appreciated.
> Thanks in advance,
> Tom
>|||Tibor,
Thanks for the fast response, but I think the problem is deeper that that.
I can not even get the instance of SQL server to start. When I try to start
the service I get an NT internal error. Could this be because I lost both
master and msdb databases as well as my user databases? I do have
backups(master,msdb,...), but without having SQL running , I cant restore
them. Any other suggestions?
Thanks for your time.
Tom
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uEzBcW6YEHA.3128@.TK2MSFTNGP09.phx.gbl...
> Tom,
> Use your backups instead of trying to move the database files. On case
you, for some reason, don't want to use
> the backups, you can try to copy the mdf, ndf and ldf files that
constitutes each database and attach them to
> the working SQL Server using sp_attach_db.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message
news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
>|||Check out the SQL Server errorlog.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message news:ui%23Zs4FZEHA.2388@.TK2MSFTNGP09.
phx.gbl...
> Tibor,
> Thanks for the fast response, but I think the problem is deeper that that.
> I can not even get the instance of SQL server to start. When I try to star
t
> the service I get an NT internal error. Could this be because I lost both
> master and msdb databases as well as my user databases? I do have
> backups(master,msdb,...), but without having SQL running , I cant restore
> them. Any other suggestions?
> Thanks for your time.
> Tom
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:uEzBcW6YEHA.3128@.TK2MSFTNGP09.phx.gbl...
> you, for some reason, don't want to use
> constitutes each database and attach them to
> news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
>
Last night we had 2 drives die on our test machine. The data (all our
databases)has been regretably lost. My question is;
How can I use the Production box and copy all the databases over to the
newly installed drives? At this point, I am unable to even start the sql
server service. SQL 7 on NT4 both machines.
Any advice on how to recover this nightmare would be appreciated.
Thanks in advance,
TomTom,
Use your backups instead of trying to move the database files. On case you,
for some reason, don't want to use
the backups, you can try to copy the mdf, ndf and ldf files that constitutes
each database and attach them to
the working SQL Server using sp_attach_db.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.ph
x.gbl...
> Hello all,
> Last night we had 2 drives die on our test machine. The data (all our
> databases)has been regretably lost. My question is;
> How can I use the Production box and copy all the databases over to the
> newly installed drives? At this point, I am unable to even start the sql
> server service. SQL 7 on NT4 both machines.
> Any advice on how to recover this nightmare would be appreciated.
> Thanks in advance,
> Tom
>|||Tibor,
Thanks for the fast response, but I think the problem is deeper that that.
I can not even get the instance of SQL server to start. When I try to start
the service I get an NT internal error. Could this be because I lost both
master and msdb databases as well as my user databases? I do have
backups(master,msdb,...), but without having SQL running , I cant restore
them. Any other suggestions?
Thanks for your time.
Tom
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uEzBcW6YEHA.3128@.TK2MSFTNGP09.phx.gbl...
> Tom,
> Use your backups instead of trying to move the database files. On case
you, for some reason, don't want to use
> the backups, you can try to copy the mdf, ndf and ldf files that
constitutes each database and attach them to
> the working SQL Server using sp_attach_db.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message
news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
>|||Check out the SQL Server errorlog.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message news:ui%23Zs4FZEHA.2388@.TK2MSFTNGP09.
phx.gbl...
> Tibor,
> Thanks for the fast response, but I think the problem is deeper that that.
> I can not even get the instance of SQL server to start. When I try to star
t
> the service I get an NT internal error. Could this be because I lost both
> master and msdb databases as well as my user databases? I do have
> backups(master,msdb,...), but without having SQL running , I cant restore
> them. Any other suggestions?
> Thanks for your time.
> Tom
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n
> message news:uEzBcW6YEHA.3128@.TK2MSFTNGP09.phx.gbl...
> you, for some reason, don't want to use
> constitutes each database and attach them to
> news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
>
Recovering SQL server
Hello all,
Last night we had 2 drives die on our test machine. The data (all our
databases)has been regretably lost. My question is;
How can I use the Production box and copy all the databases over to the
newly installed drives? At this point, I am unable to even start the sql
server service. SQL 7 on NT4 both machines.
Any advice on how to recover this nightmare would be appreciated.
Thanks in advance,
TomTom,
Use your backups instead of trying to move the database files. On case you, for some reason, don't want to use
the backups, you can try to copy the mdf, ndf and ldf files that constitutes each database and attach them to
the working SQL Server using sp_attach_db.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> Hello all,
> Last night we had 2 drives die on our test machine. The data (all our
> databases)has been regretably lost. My question is;
> How can I use the Production box and copy all the databases over to the
> newly installed drives? At this point, I am unable to even start the sql
> server service. SQL 7 on NT4 both machines.
> Any advice on how to recover this nightmare would be appreciated.
> Thanks in advance,
> Tom
>|||Tibor,
Thanks for the fast response, but I think the problem is deeper that that.
I can not even get the instance of SQL server to start. When I try to start
the service I get an NT internal error. Could this be because I lost both
master and msdb databases as well as my user databases? I do have
backups(master,msdb,...), but without having SQL running , I cant restore
them. Any other suggestions?
Thanks for your time.
Tom
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uEzBcW6YEHA.3128@.TK2MSFTNGP09.phx.gbl...
> Tom,
> Use your backups instead of trying to move the database files. On case
you, for some reason, don't want to use
> the backups, you can try to copy the mdf, ndf and ldf files that
constitutes each database and attach them to
> the working SQL Server using sp_attach_db.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message
news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> > Hello all,
> >
> > Last night we had 2 drives die on our test machine. The data (all our
> > databases)has been regretably lost. My question is;
> > How can I use the Production box and copy all the databases over to the
> > newly installed drives? At this point, I am unable to even start the sql
> > server service. SQL 7 on NT4 both machines.
> > Any advice on how to recover this nightmare would be appreciated.
> > Thanks in advance,
> > Tom
> >
> >
>|||Check out the SQL Server errorlog.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message news:ui%23Zs4FZEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Tibor,
> Thanks for the fast response, but I think the problem is deeper that that.
> I can not even get the instance of SQL server to start. When I try to start
> the service I get an NT internal error. Could this be because I lost both
> master and msdb databases as well as my user databases? I do have
> backups(master,msdb,...), but without having SQL running , I cant restore
> them. Any other suggestions?
> Thanks for your time.
> Tom
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uEzBcW6YEHA.3128@.TK2MSFTNGP09.phx.gbl...
> > Tom,
> >
> > Use your backups instead of trying to move the database files. On case
> you, for some reason, don't want to use
> > the backups, you can try to copy the mdf, ndf and ldf files that
> constitutes each database and attach them to
> > the working SQL Server using sp_attach_db.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message
> news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> > > Hello all,
> > >
> > > Last night we had 2 drives die on our test machine. The data (all our
> > > databases)has been regretably lost. My question is;
> > > How can I use the Production box and copy all the databases over to the
> > > newly installed drives? At this point, I am unable to even start the sql
> > > server service. SQL 7 on NT4 both machines.
> > > Any advice on how to recover this nightmare would be appreciated.
> > > Thanks in advance,
> > > Tom
> > >
> > >
> >
> >
>
Last night we had 2 drives die on our test machine. The data (all our
databases)has been regretably lost. My question is;
How can I use the Production box and copy all the databases over to the
newly installed drives? At this point, I am unable to even start the sql
server service. SQL 7 on NT4 both machines.
Any advice on how to recover this nightmare would be appreciated.
Thanks in advance,
TomTom,
Use your backups instead of trying to move the database files. On case you, for some reason, don't want to use
the backups, you can try to copy the mdf, ndf and ldf files that constitutes each database and attach them to
the working SQL Server using sp_attach_db.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> Hello all,
> Last night we had 2 drives die on our test machine. The data (all our
> databases)has been regretably lost. My question is;
> How can I use the Production box and copy all the databases over to the
> newly installed drives? At this point, I am unable to even start the sql
> server service. SQL 7 on NT4 both machines.
> Any advice on how to recover this nightmare would be appreciated.
> Thanks in advance,
> Tom
>|||Tibor,
Thanks for the fast response, but I think the problem is deeper that that.
I can not even get the instance of SQL server to start. When I try to start
the service I get an NT internal error. Could this be because I lost both
master and msdb databases as well as my user databases? I do have
backups(master,msdb,...), but without having SQL running , I cant restore
them. Any other suggestions?
Thanks for your time.
Tom
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uEzBcW6YEHA.3128@.TK2MSFTNGP09.phx.gbl...
> Tom,
> Use your backups instead of trying to move the database files. On case
you, for some reason, don't want to use
> the backups, you can try to copy the mdf, ndf and ldf files that
constitutes each database and attach them to
> the working SQL Server using sp_attach_db.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message
news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> > Hello all,
> >
> > Last night we had 2 drives die on our test machine. The data (all our
> > databases)has been regretably lost. My question is;
> > How can I use the Production box and copy all the databases over to the
> > newly installed drives? At this point, I am unable to even start the sql
> > server service. SQL 7 on NT4 both machines.
> > Any advice on how to recover this nightmare would be appreciated.
> > Thanks in advance,
> > Tom
> >
> >
>|||Check out the SQL Server errorlog.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message news:ui%23Zs4FZEHA.2388@.TK2MSFTNGP09.phx.gbl...
> Tibor,
> Thanks for the fast response, but I think the problem is deeper that that.
> I can not even get the instance of SQL server to start. When I try to start
> the service I get an NT internal error. Could this be because I lost both
> master and msdb databases as well as my user databases? I do have
> backups(master,msdb,...), but without having SQL running , I cant restore
> them. Any other suggestions?
> Thanks for your time.
> Tom
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uEzBcW6YEHA.3128@.TK2MSFTNGP09.phx.gbl...
> > Tom,
> >
> > Use your backups instead of trying to move the database files. On case
> you, for some reason, don't want to use
> > the backups, you can try to copy the mdf, ndf and ldf files that
> constitutes each database and attach them to
> > the working SQL Server using sp_attach_db.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > "TLF" <T_DONOTSPAM_Furness@.simon.com> wrote in message
> news:uz2pqp5YEHA.1448@.TK2MSFTNGP12.phx.gbl...
> > > Hello all,
> > >
> > > Last night we had 2 drives die on our test machine. The data (all our
> > > databases)has been regretably lost. My question is;
> > > How can I use the Production box and copy all the databases over to the
> > > newly installed drives? At this point, I am unable to even start the sql
> > > server service. SQL 7 on NT4 both machines.
> > > Any advice on how to recover this nightmare would be appreciated.
> > > Thanks in advance,
> > > Tom
> > >
> > >
> >
> >
>
Subscribe to:
Posts (Atom)