-
commit transation log without bkup- Copy mdf and ldf to SAN then restore
We have a 30+GB database, this database has some files in SQL and some files in another application.
We would like to implement the followings, if it is possible:
1- Take database offline
2- Commit everything
3- Copy .mdf and .ldf files to SAN
4- Snap copy everything from San
5- Take database online.
My questions here are:
1- Can we restore from the copy files we will place into SAN?
2- Can you commit transaction logs without doing backup?
I read http://forums.databasejournal.com/sh...ghlight=rename
Article but I am not sure if this would apply here for the restore part.
anam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|