SQL Query to Take back up of Database
sp_helpdb reportserver
go
sp_helpdb reportservertempdb
backup database reportserver to disk='D:\scripts\ssrs\reportserver.bak' with init, stats=1
go
backup database reportservertempdb to disk='D:\scripts\ssrs\reportservertempdb.bak' with init, stats=1
sp_helpdb reportserver
go
sp_helpdb reportservertempdb
backup database reportserver to disk='D:\scripts\ssrs\reportserver.bak' with init, stats=1
go
backup database reportservertempdb to disk='D:\scripts\ssrs\reportservertempdb.bak' with init, stats=1
No comments:
Post a Comment