How to attach a database to MS sql server 2012?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
136 views
Hello,
There is such a situation , detach database from sql server, where for a couple of months maybe a little more, as it was not needed, when needed, to join refused referring to a file error log, the file does not match the database, but the log file I did not change, even with the backups took other files (and made backup of the HDD) but the situation is the same, what could be wrong? and how to fix the Internet saw manual www.googli.com.ua/sol/122_123 but is it possible to implement it on the battle server? maybe there are any options?
5c4fda6bda10a271041326.png
by | 136 views

2 Answers

0 like 0 dislike
You must run the command:

use master
go
create database new_database_name
on (filename = 'D:\\Data\\database.Mdf')
for attach
go
by
0 like 0 dislike
Backups are necessary not just to do, and sometimes to check whether recovering the old ones.
Here we see that DB in inconsistentname condition. Which backup did you do the HDD - it does not guarantee the integrity of the database, the database should backup a DBMS.
I think this is responsible for the database and backup it's time to smear your ass with vaseline.
by

Related questions

0 like 0 dislike
2 answers
0 like 0 dislike
2 answers
0 like 0 dislike
2 answers
0 like 0 dislike
2 answers
0 like 0 dislike
1 answer
110,608 questions
257,187 answers
0 comments
40,249 users