SQL : Différence entre versions

De Wiki-noulot
Sauter à la navigation Sauter à la recherche
(Page créée avec « =SQL= ==Lister les Tables d'une base MSSQL== SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE = 'BASE TABLE' »)
 
Ligne 6 : Ligne 6 :
 
  FROM INFORMATION_SCHEMA.TABLES
 
  FROM INFORMATION_SCHEMA.TABLES
 
  WHERE TABLE_TYPE = 'BASE TABLE'
 
  WHERE TABLE_TYPE = 'BASE TABLE'
 +
 +
==Problème de restoring d'une base==
 +
 +
SELECT name, state_desc
 +
FROM sys.databases
 +
WHERE name = 'EVO_CONFIG50004'
 +
 +
 +
 +
SELECT r.session_id, r.command, r.status, r.percent_complete, r.start_time,
 +
      db.name AS database_name, r.wait_type, r.wait_time, r.wait_resource
 +
FROM sys.dm_exec_requests r
 +
JOIN sys.databases db ON r.database_id = db.database_id
 +
WHERE db.name = 'EVO_CONFIG50004'
 +
 +
 +
EXEC xp_readerrorlog 0, 1, N'Database', N'Restore';
 +
 +
 +
RESTORE DATABASE [EVO_CONFIG50004] WITH RECOVERY;

Version du 14 juin 2024 à 14:06

SQL

Lister les Tables d'une base MSSQL

SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'

Problème de restoring d'une base

SELECT name, state_desc FROM sys.databases WHERE name = 'EVO_CONFIG50004'


SELECT r.session_id, r.command, r.status, r.percent_complete, r.start_time,

      db.name AS database_name, r.wait_type, r.wait_time, r.wait_resource

FROM sys.dm_exec_requests r JOIN sys.databases db ON r.database_id = db.database_id WHERE db.name = 'EVO_CONFIG50004'


EXEC xp_readerrorlog 0, 1, N'Database', N'Restore';


RESTORE DATABASE [EVO_CONFIG50004] WITH RECOVERY;